1

I am having an issue where the DB resources are being used up by someone in the business external to the application. Ignoring how unsafe and incompetent this is as it's not my business, how can I see the CPU usage of the DB server over a longer period of time. I use SysGauge to monitor the live statistics of the server but that only goes back over a 5 minute period. I've also tried the Microsoft SQL Server Performance Dashboard report but that only seems to go back over a 15 minute period. I need something that will allow me to look back over the current day's usage, does anyone know of either an inbuilt SQL report that can give me this or a open source external tool?

Microsoft SQL Server Performance Dashboard

enter image description here

SysGuage

enter image description here

1 Answer 1

5

There is quite a lot.

to name but few.

1
  • That's brilliant, thank you so much
    – cullimorer
    Oct 20, 2022 at 9:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.