How to find CPU usage by database over a time period

lup328lup328 Posts: 3 Bronze 1
edited January 4, 2016 6:51AM in SQL Monitor Previous Versions
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,

Comments

  • 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.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.