Red Gate forums :: View topic - 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 2
SQL Monitor 2 forum

High CPU Usage

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
xexex



Joined: 24 Jun 2010
Posts: 41

PostPosted: Thu Feb 02, 2012 7:30 am    Post subject: 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 found which query cuased in SQL monitor?
Back to top
View user's profile Send private message
xexex



Joined: 24 Jun 2010
Posts: 41

PostPosted: Thu Feb 02, 2012 7:45 am    Post subject: Reply with quote

Problem found.
A programmer said that he inserted 500K records before.........

However, can I found which query using SQL Monitor?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 925
Location: Red Gate Software

PostPosted: Fri Feb 03, 2012 4:01 pm    Post subject: Reply with quote

Thank you for your posts into the forum and excellent news that you identified the cause of your high CPU usage.

Was SQL Monitor able to generate a Long Running Query alert for the query running the insert statement? If the answer was yes, was the information in the alert helpful to you?

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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