October 1, 2012 at 8:31 am
Hi all
I have been trying to get the WMI provider for SQL Server Events to work by. following this article.
http://msdn.microsoft.com/en-us/library/ms186385.aspx
However its not working as nothing is being written to the table even though the deadlock is produced. I have enable service broker on the databases involved. Is it possible to query the WMI queue or the service to see if anything is being put into it?
Thanks
October 1, 2012 at 10:21 am
Does the Sql Agent Job fire successfully when the deadlock occurs?
Also, are you using a named instance? In the sample code, at the bottom,
@wmi_namespace=N'\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER'
"MSSQLSERVER" will be different for a named instance.
October 1, 2012 at 12:12 pm
Hi there - its the default instance so I believe that should be correct. I am not at work at present, but will check if the job fired, would there be a history as normal?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply