SQLServerCentral / 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 / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 06:26:05 GMT20RE: HOw to get Automatic Email notification for High CPU Utilization >80 % with the query which is causing the high CPU usagehttp://www.sqlservercentral.com/Forums/Topic1418310-360-1.aspxthanks look like i get what i was looking for........ will post the entire process step by step so that other can get the details and use it in there work.....Wed, 13 Feb 2013 00:22:25 GMTIvan MohapatraRE: HOw to get Automatic Email notification for High CPU Utilization >80 % with the query which is causing the high CPU usagehttp://www.sqlservercentral.com/Forums/Topic1418310-360-1.aspxBing "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%.Tue, 12 Feb 2013 07:54:54 GMTopc.threeRE: HOw to get Automatic Email notification for High CPU Utilization >80 % with the query which is causing the high CPU usagehttp://www.sqlservercentral.com/Forums/Topic1418310-360-1.aspxhi,well as for now no 3rd party tool & WMI Alert can you pass me the script or any link through which i can get some idea........Tue, 12 Feb 2013 01:06:34 GMTIvan MohapatraRE: HOw to get Automatic Email notification for High CPU Utilization >80 % with the query which is causing the high CPU usagehttp://www.sqlservercentral.com/Forums/Topic1418310-360-1.aspxTry third party tools........like sentry or nagios alerts.Mon, 11 Feb 2013 11:26:00 GMTdeep_kkumarRE: HOw to get Automatic Email notification for High CPU Utilization >80 % with the query which is causing the high CPU usagehttp://www.sqlservercentral.com/Forums/Topic1418310-360-1.aspxI am not sure how you could alert based on one specific query causing 80% CPU use because SQL Server abstracts a lot of that but you could get a list of all the queries and their CPU use for analysis when the server goes above 80% CPU use. You could do this by setting up a WMI Alert in SQL Agent that would run a job when CPU reached 80% on the server. The job could capture all running queries. Be careful with this kind of approach though, it can make bad times worse depending on how aggressive your job is at pulling information from the server.Mon, 11 Feb 2013 07:23:18 GMTopc.threeHOw to get Automatic Email notification for High CPU Utilization >80 % with the query which is causing the high CPU usagehttp://www.sqlservercentral.com/Forums/Topic1418310-360-1.aspxhi all,Do any one have any script by which i can get a automatic email notification when a HIGH CPU usage n >80 % occurs on the Sql server 2005 instance with the query which is causing the high CPU usage.thanksMon, 11 Feb 2013 04:29:11 GMTIvan Mohapatra