What is the best way to detemine the cause of Processor Utilization High with no Top Queries
Ed_Thompson
Posts: 3 New member
I have a SQL Server that over a 15 hour period raised the Processor Utilization High alert 10 times. Each time the processor was pegged nearly the whole time at 100% and it lasted between 4 and 7 minutes; but, there were no Top Queries listed even when the Systems Processes tab showed sqlserver.exe as the high consumer. I see that setting Trace On is not advised unless there is a known issue; if I respond to the alert by turning Trace on in order to potentially capture the cause, that would make it worse wouldn't it? Where is a good place to look at how to do a post mortem analysis for this?
Tagged:
Answers
This page https://documentation.red-gate.com/sm9/overview-pages/using-performance-diagnostics goes over the general performance diagnostics use case, but it sounds like you may have done just that (get the alert and check the information provided there, then check the Server overview focused on the time of the alert to check queries and waits).
This page https://www.red-gate.com/hub/product-learning/sql-monitor/monitoring-sql-server-performance-whats-required may also be interesting for you to look into.
Is it possible that the load on your server wasn't down to a specific process? Also, is the machine you're monitoring a VM? If so, perhaps it just wasn't getting the resource it thought it could from the host.
Kind regards,
Alex
Have you visited our Help Center?