Which query needs high cpu usage?

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Which query needs high cpu usage?

Postby mschier » Thu Jun 26, 2014 9: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: 12
Joined: Mon Jan 13, 2014 10:22 am

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

no ideas?
Posts: 12
Joined: Mon Jan 13, 2014 10:22 am

Postby chriskelly » Wed Jul 02, 2014 9: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
Posts: 373
Joined: Mon Apr 19, 2010 12:44 pm
Location: Cambridge, UK

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests