December 15, 2015 at 11:00 am
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
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy