July 10, 2014 at 10:35 pm
I have downloaded SSMS Addin for extended events. I would like to configure Block Process Report on a server and receive notification every time if blocking happens.
I created the same process in SQL Server 2012 and trying to deploy in SQL 2008 R2 64 Bit server environment. I get the error on the first place to create event session. Here is the error message
CREATE EVENT SESSION [MonitorBlocking] ON SERVER
ADD EVENT sqlserver.blocked_process_report
ADD TARGET package0.ring_buffer(SET max_memory=(2048))
WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=5 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)
GO
Here is the Error:
Msg 25623, Level 16, State 1, Line 1
The event name, "sqlserver.blocked_process_report", is invalid, or the object could not be found
Any help is greatly appreciated in this regard.
We have company wide policy not to go with Service Broker - Event notification route.
I need to configure Extended events and capture the block_process_report events whenever blocking occurs.
Is this doable?
Thanks,
July 11, 2014 at 5:25 am
According to Jonathan Kehayias (http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/12/21/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali.aspx) the event you are trying to add was added in Denali. That may explain the error.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply