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

Automated e-mail from sql server 2005 when the CPU utilization is high Expand / Collapse
Author
Message
Posted Tuesday, November 20, 2012 10:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 22, 2012 8:44 PM
Points: 4, Visits: 18
Hi Friend,

Is is possilbe to have an automated e-mail from sql server 2005 when the CPU utilization is high
to add on, it would be really helpfull if the automate e-mail comes with the query and its long execution timings which is causing the trouble .

If any one can help me on this

Thanks
Taro
Post #1387056
Posted Tuesday, November 20, 2012 12:17 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
There isn't a native tool for that. You could schedule a job that would periodically check the CPU level and do what you needed if it found it out of range.

Most shops would use a standard 3rd party tool for that. Red Gate SQL Monitor might do what you need (see link at top-right of this page). Solar Winds can monitor that kind of thing pretty well. There are other tools if you Bing/Google "monitor SQL Server CPU", you'll find a number of products, and you can compare features and prices and call the companies if you have questions.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1387100
Posted Wednesday, November 21, 2012 4:22 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 5:22 AM
Points: 709, Visits: 1,412
What about using perfmon to check CPU utilization and send an e-mail alert if it is over a set threshold? You could even instead of having perfmon send an e-mail have perfmon run a query through sqlcmd that does the query and uses sp_send_dbmail to send you the result.

Joie Andrew
"Since 1982"
Post #1387347
Posted Thursday, November 22, 2012 2:04 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, July 19, 2014 8:45 AM
Points: 531, Visits: 2,078
Quite some time ago I implemented three processes in SQL. The first one was CPU intenstive, the second was I/O intensive and the third one was Network intensive. I actually ran these processes via a scheduler and then measured how much elapsed time each took. When the elapsed time wend beyond a certain threshold X times a day it would fire an email.
It's a bit of a different approach. But I found it very effective.
Post #1387763
Posted Monday, November 26, 2012 8:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 7, 2014 4:07 AM
Points: 5, Visits: 174
How to Monitor for High CPU utilization in SQL Server >
http://www.sqlservercentral.com/articles/CPU/71388

Regards.
Post #1388659
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse