How to find CPU usage by database over a time period

lup328

Is this possible from data collected by SQL Monitor?
If yes, how?
Has anyone done this already? Or a script to add this ?

Thank you in advance,

Dan B

Hi Lup328,

Thanks for posting on the Redgate forums.

Unfortunately, I don't think this is possible. SQL monitor doesn't collect this information.

If you investigate this thread http://stackoverflow.com/questions/2895 ... y-database you can see why this might not be possible. You would be able to add the scripts in this thread to a custom metric in SQL monitor but these don't report on individual databases rather individual queries.