High CPU Usage

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

High CPU Usage

Postby xexex » Thu Feb 02, 2012 7:30 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 found which query cuased in SQL monitor?
xexex
 
Posts: 41
Joined: Thu Jun 24, 2010 5:50 am

Postby xexex » Thu Feb 02, 2012 7:45 am

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

However, can I found which query using SQL Monitor?
xexex
 
Posts: 41
Joined: Thu Jun 24, 2010 5:50 am

Postby eddie davis » Fri Feb 03, 2012 4:01 pm

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
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests