Send Alert if CPU is 100%

Question

Send Alert if CPU is 100%

Dimpal

SSC Enthusiast

Points: 173
More actions
September 10, 2004 at 10:18 am

#83973

How to write and query which will alert me if CPU is 100% usage.

Thanks

Dimpal Patel
September 13, 2004 at 8:00 am

This was removed by the editor as SPAM

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

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

iLoveSQL SSCrazy Points: 2888 More actions · Answer 1

I don't know how to do that from pure SQL query but I know how to do that from Windows "Performance Logs and Alerts"

From coomputer Management->Performance Logs and Alerts->Alerts and setup the New Alert Settings and you can set to send an network message or run this program. And using simple send mail program like "Blat" to send email out..

We are using 3rd party software (SiteScope http://www.mercury.com/us/)

Love it.

just 2 cents

Dimpal SSC Enthusiast Points: 173 More actions · Answer 2

Thanks, But I don't want to use third software tool.

Dimpal Patel

iLoveSQL SSCrazy Points: 2888 More actions · Answer 3

The first suggestion wasn't third party software.. well sending email part is third party software but that is freeware and rock solid program so easy way solution.

You can make it to spit out to file and let sql to catch the file and send email by using xp_sendmail but too much for that.. 😛

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 4

Hello,

Do you like scripts? There is a Scripting repository on Technet and there is a script for CPU usage:

http://www.microsoft.com/technet/community/scriptcenter/monitor/scrmon26.mspx

******************

Monitor Processor Use

Updated: February 17, 2003

Description

Uses cooked performance counters to monitor processor use on a computer. Triggers an alert if processor use exceeds 90 percent on 10 successive measurements (measured at 6-second intervals).

**************

For all other DBAs and Developers: On Microsoft.com click on "For IT Pros" Technet in the middle of the page, they moved it recently. There click on Script Center in the left pane. Once there click Browse The Repository in the middle of the page. For this particular question I selected Monitoring from the list and click on Monitor Processor Use from the other list.

And do check out Enterprise Scripts section! there are database and ADO usage scripts and scripts that send emails.

Yelena

Regards,Yelena Varsha