Hot to set Alerts.

• MasterDB

  Hall of Fame

  Points: 3054

  More actions

  September 8, 2011 at 11:48 pm

  #247769

  Hi Folks,

  A front-end[ASP] application hangs for some time, for that application we are using SQL SERVER Database as Back-end.

  At that point of time CPU utilization by SQL Server is almost 100.

  Can anyone help me how to set alerts if SQL SERVER utilizing more than 80% CPU?. And how to set alerts if Front-end application hangs.

  TIA..

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  September 9, 2011 at 12:05 am

  #1379006

  http://sqlknowledge.com/2010/12/how-to-monitor-sql-server-cpu-usage-and-get-auto-alerts/

  http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/be93e3d7-5ac5-4a96-b131-a5ea275b72fb

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/