Database centric resources

Deltona

Hi,

- How would i create a view that lists all my databases instead of SQL servers/instances. I want databases to be listed in raw format.

- How do i create a Top xx for databases?

- I would like to know which monitored DB is the biggest DB. Top XX Databases by Size

- Whcih Database is generating the most IOPS? Which Database has the most connections etc.

I am not able to get this data as it seems like AppInsight is still too server centric.

It is mkay when you have a couple databases but very time consuming when you have 300+ databases.

Can we please get som database centric resources?

Thanks for reading.

aLTeReGo

This can be done today using the Custom Table Resource no differently than you would within a report. There's also some amazing things people are doing with the Custom SQL Resource to build their own Orion resources.