Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Monitor High CPU Expand / Collapse
Author
Message
Posted Monday, February 20, 2012 4:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 7, 2014 5:18 AM
Points: 85, Visits: 205
Hi All,
I created an alert under sql server agent alerts.
I selected type as sql server performance condition alert, Object:Sql server :Resource Pool Stats,Counter :Cpu usage %, Instance:default,Alert if:Counter rises above 40.

I made response trigger running a job and notify database operator using email.

I ran some sqls to trigger high CPU usage but the alert is never triggered and nothing happens!!.

Looking forward for your feedback.
Nader
Post #1254652
Posted Monday, February 20, 2012 5:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:41 AM
Points: 1,320, Visits: 2,554
nadersam (2/20/2012)
Hi All,
I created an alert under sql server agent alerts.
I selected type as sql server performance condition alert, Object:Sql server :Resource Pool Stats,Counter :Cpu usage %, Instance:default,Alert if:Counter rises above 40.

I made response trigger running a job and notify database operator using email.

I ran some sqls to trigger high CPU usage but the alert is never triggered and nothing happens!!.

Looking forward for your feedback.
Nader


Did the CPU touched 40% baseline during the tests??



Sujeet Singh
Post #1254670
Posted Monday, February 20, 2012 6:08 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 7, 2014 5:18 AM
Points: 85, Visits: 205
Thanks for your reply.
It went above 70 %
Post #1254689
Posted Monday, February 20, 2012 6:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:41 AM
Points: 1,320, Visits: 2,554
nadersam (2/20/2012)
Thanks for your reply.
It went above 70 %


I think the alert considers "100" as "1.0" as CPU is calculated by its base, so you need to set the baseline to "0.4" if you want to get the alert mail on CPU usage > 40%.



Sujeet Singh
Post #1254707
Posted Monday, February 20, 2012 7:00 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 7, 2014 5:18 AM
Points: 85, Visits: 205
i did that and still nothing happening and i checked history for alert, i even change value to 0.1 to be sure and restarted sql agent and run slow sqls again
Thanks
Post #1254719
Posted Wednesday, February 22, 2012 4:14 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 7, 2014 5:18 AM
Points: 85, Visits: 205
As a test i changed the alert to datafile size above a certain number and the alert was fired and i got a mail for it, still can't get the CPU usage % under SQLServer:Resource Pool Stats to work
Thanks
Post #1255834
Posted Tuesday, April 16, 2013 12:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 12:18 PM
Points: 2, Visits: 35
Same for me. The alert does not fire.

SQLServer: Resource Pool Stats
Counter: CPU usage%
Instance: default
Alert when couter rise above: 0.01

I do have alerts for different stuff that works fine.
Post #1442953
Posted Wednesday, October 30, 2013 2:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 21, 2014 1:59 PM
Points: 1, Visits: 20
Use object: Workload Group Stats
And Value in number percent format: 0.00 = 0% between 1.00 = 100%
Options: delay between responses: 2 minutes
Worked on SQL Server 2012 SP1 Cluster Instance

Cheers,
Post #1509939
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse