Defining CPU saturation WMI alert in SQL Server 2005

• imarchenko-236376

  SSCommitted

  Points: 1734

  More actions

  March 8, 2006 at 3:39 pm

  #116425

  Hello!

   

      I am trying to define WMI alert monitoring certain OS counters. Specifically, I would like to get notified if total CPU consumption will go above given threshold.

      Alert definition requires me to enter namespace and query. I was wondering if anybody has done something similar in SQL Server 2005. I am not what namespace I should be using (is there is a lit of namespaces for every OS counter: CPU, Page file etc.). Also, I do not know how to express condition I need using WQL - 'total CPU consumption>=<defined threshold>.

   

  Thanks,

  Igor

• March 13, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  March 13, 2006 at 12:28 pm

  #626343

  I did not really find one for CPU for alerts.  See

  http://msdn2.microsoft.com/ko-kr/library/ms186449(SQL.90).aspx

  WMI Provider for Server Events Classes and Properties  

  You may want to try more traditional WMI as in

  http://windowssdk.msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/wmi_tasks__performance_monitoring.asp

  WMI Tasks: Performance Monitoring

   

  Regards,Yelena Varsha