| Author |
Message |
xexex
Joined: 24 Jun 2010
Posts: 31
|
 Posted: Thu Feb 02, 2012 7:30 am Post subject: High CPU Usage |
 |
|
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 |
|
 |
xexex
Joined: 24 Jun 2010
Posts: 31
|
| Posted: Thu Feb 02, 2012 7:45 am Post subject: |
|
|
Problem found.
A programmer said that he inserted 500K records before.........
However, can I found which query using SQL Monitor? |
|
| Back to top |
|
|
eddie davis
Joined: 14 Jun 2006
Posts: 796
Location: Red Gate Software
|
| Posted: Fri Feb 03, 2012 4:01 pm Post subject: |
|
|
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 |
|
|
|
|
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
