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

Question

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

taroboyy

SSC Enthusiast

Points: 100
More actions
November 20, 2012 at 10:46 am

#266306

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

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

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 2

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"

Michael Meierruth SSChampion Points: 10051 More actions · Answer 3

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.

alfgomled SSC Journeyman Points: 77 More actions · Answer 4

How to Monitor for High CPU utilization in SQL Server >

http://www.sqlservercentral.com/articles/CPU/71388

Regards.