<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 7,2000
»
SQL Server Agent
»
Monitor High CPU
Monitor High CPU
Rate Topic
Display Mode
Topic Options
Author
Message
nadersam
nadersam
Posted Monday, February 20, 2012 4:40 AM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, April 17, 2013 12:55 AM
Points: 81,
Visits: 189
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
Divine Flame
Divine Flame
Posted Monday, February 20, 2012 5:12 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 2:00 PM
Points: 1,076,
Visits: 1,914
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??
- Divine Flame
Post #1254670
nadersam
nadersam
Posted Monday, February 20, 2012 6:08 AM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, April 17, 2013 12:55 AM
Points: 81,
Visits: 189
Thanks for your reply.
It went above 70 %
Post #1254689
Divine Flame
Divine Flame
Posted Monday, February 20, 2012 6:41 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 2:00 PM
Points: 1,076,
Visits: 1,914
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%.
- Divine Flame
Post #1254707
nadersam
nadersam
Posted Monday, February 20, 2012 7:00 AM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, April 17, 2013 12:55 AM
Points: 81,
Visits: 189
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
nadersam
nadersam
Posted Wednesday, February 22, 2012 4:14 AM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, April 17, 2013 12:55 AM
Points: 81,
Visits: 189
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
Petros Sigalos
Petros Sigalos
Posted Tuesday, April 16, 2013 12:53 PM
Forum Newbie
Group: General Forum Members
Last Login: Monday, May 13, 2013 1:16 PM
Points: 1,
Visits: 23
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
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
