Can I create a dashboard for Database summaries?

Question

Question by Jared K. · Apr 10, 2015 at 08:04 AM · production

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?

0

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 1 · 2015-04-10T08:57:19Z

Answer by David M. · Apr 10, 2015 at 08:57 AM

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

0 Show 1 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Jared K. · Apr 11, 2015 at 12:41 AM 0

Share

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.

Can I create a dashboard for Database summaries?

1 Reply

How to get started:

NAM 2019 SP3 is available

LIVE WEBINAR

Follow this Question

Related Questions

Forum Tags