Which query needs high cpu usage?

SQL Server performance monitoring and alerting

Which query needs high cpu usage?

Postby mschier » Thu Jun 26, 2014 10:12 am

A Processor utilization alert has been obtained in SQL monitor, the CPU usage is 100% over 15 mins, and there are many Long running query alerts which cuased by "Process name: SQL Monitor - Monitoring".

Did SQL monitor caused the high CPU usage? if no, how can I add a custom alert who found which query caused in SQL monitor?
Posts: 4
Joined: Mon Jan 13, 2014 11:22 am

Postby mschier » Wed Jul 02, 2014 7:53 am

no ideas?
Posts: 4
Joined: Mon Jan 13, 2014 11:22 am

Postby chriskelly » Wed Jul 02, 2014 10:44 am

I'm sorry that no one got back to you.

It might be that there was a significant increase in data to be collected and the Base Monitor host struggled to keep up, but quickly did so within the 15 minutes and so returned to normal.

If it happens regularly then it can be concerning, but can also indicate that a regular task is contributing to the problem. Can you send the SQL Monitor error log files to support at support@red-gate.com and quote this forum post in your email.

https://documentation.red-gate.com/page ... d=20743048
Chris Kelly
Technical Support Engineer
Posts: 368
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 3 guests