Create WMI Alert

• ERIC CRUDELI

  SSCommitted

  Points: 1786

  More actions

  December 15, 2015 at 11:00 am

  #323077

  Hi,

  I have server with Windows server R2 and SQL 2014 SP1.

  I tried to create a WMI Alert

  USE [msdb]

  GO

  EXEC msdb.dbo.sp_add_alert @name=N'Alert System : System : Processor Queue Length > 20',

  @enabled=1,

  @delay_between_responses=0,

  @include_event_description_in=0,

  @wmi_namespace=N'\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER',

  @wmi_query=N'SELECT * FROM __InstanceModificationEvent WITHIN 10 WHERE TargetInstance ISA "Win32_PerfFormattedData_PerfOS_System" AND TargetInstance.ProcessorQueueLength > 20'

  I got a error message :

  Msg 22022, Level 16, State 1, Line 0

  SQLServerAgent Error: WMI error: 0x80041003.

  Msg 14511, Level 16, State 1, Procedure sp_verify_alert, Line 300

  The @wmi_query could not be executed in the @wmi_namespace provided. Verify that an event class selected in the query exists in the namespace and that the query has the correct syntax.

  Any idea to fix the issue.

  I ran WMIDIAG on server (see reports). I saw some errors but I don't know if it's the main reason of issue.

  Thanks

  Eric