Post reply

Send Alert if CPU is 100%

  • 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

  • September 13, 2004 at 11:37 am

    #522811

    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

     

  • September 14, 2004 at 7:52 am

    #522958

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


    Dimpal Patel

  • September 14, 2004 at 8:38 am

    #522972

    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.. 😛

  • September 14, 2004 at 9:08 am

    #522987

    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

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

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