Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning HOw to get Automatic Email notification for High CPU Utilization >80 % with the query which is causing the high CPU usage RE: HOw to get Automatic Email notification for High CPU Utilization >80 % with the query which is causing the high CPU usage

  • February 12, 2013 at 7:54 am

    #1587029

    Bing "wmi alert" to read about them for SQL Server Agent. Also lookup "ssis wmi event watcher" not because you need to use the object in ssis but because the msdn article has a sample WMI event query that will fire when CPU use goes above 80%.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato