Red Gate forums :: View topic - Which query needs high cpu usage?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 4
SQL Monitor 4 forum

Which query needs high cpu usage?

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mschier



Joined: 13 Jan 2014
Posts: 4

PostPosted: Thu Jun 26, 2014 10:12 am    Post subject: Which query needs high cpu usage? Reply with quote

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?
Back to top
View user's profile Send private message
mschier



Joined: 13 Jan 2014
Posts: 4

PostPosted: Wed Jul 02, 2014 7:53 am    Post subject: Reply with quote

no ideas?
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 327
Location: Cambridge, UK

PostPosted: Wed Jul 02, 2014 10:44 am    Post subject: Reply with quote

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/pages/viewpage.action?pageId=20743048
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group