Automated e-mail from sql server 2005 when the CPU utilization is high

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Automated e-mail from sql server 2005 when...

Automated e-mail from sql server 2005 when the CPU utilization is high

Rate Topic

Display Mode

Topic Options

Author

Message

taroboyy

Posted Tuesday, November 20, 2012 10:46 AM

Forum 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

GSquared

Posted Tuesday, November 20, 2012 12:17 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

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

Joie Andrew

Posted Wednesday, November 21, 2012 4:22 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 06, 2013 5:58 AM
Points: 535, Visits: 1,010

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

Michael Meierruth

Posted Thursday, November 22, 2012 2:04 AM

SSC-Addicted

Group: General Forum Members
Last Login: Sunday, May 05, 2013 10:12 AM
Points: 480, Visits: 1,604

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

alfgomled

Posted Monday, November 26, 2012 8:37 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 25, 2013 4:04 AM
Points: 4, Visits: 155

How to Monitor for High CPU utilization in SQL Server >
http://www.sqlservercentral.com/articles/CPU/71388

Regards.

Post #1388659

« Prev Topic | Next Topic »

Permissions