Can I create a dashboard for Database summaries?
Currently we only have a license for dynatrace 6.1.
I have a request from a database administrator to see if we could possibly assist him with a dashboard to tell database size on a sql server. I don't see an explicit plugin or sensor that would do this for us.
He was also working on a job that he was going to run through SSIS that queried all of their servers and wrote the database size values to a table. Is it possible to track SSIS executions?
If the above is possible I know we can see database inserts that it is making in the sql query. I also know I can create a dashboard via filters to only show the given inserts. Can we break out columns and create measurements/alerts based on the values?
Hi Jared,
I'm not sure if you saw this plugin DB Query Monitor Plugin but you may be able to leverage it by writing a query to pull back the DB size and then capture that content.
Someone else would have to answer your question about tracking SSIS executions.
Thanks,
David
I had not, that I think will work perfectly for my needs and will negate the requirement of tracking SSIS since all I want is the table information anyways. Thanks a lot for this.
