Skip to main content
1 of 3

Blocking Extended events

I have very basic table CREATE TABLE [dbo].[Table_1]( [Test] [int] NULL) & sp_configure'block process threshold', 1 --> 1 sec go

To create blocking, in 1 session i executed

Begin tran Update [dbo].[Table_1] set [Test]=1

and another session select * from [dbo].[Table_1]

when i setup extended events, i got below

select * from [dbo].[Table_1] **DECLARE @edition sysname; SET @edition = cast(SERVERPROPERTY(N'EDITION') as sysname); select case when @edition = N'SQL Azure' then 2 else 1 end as 'DatabaseEngineType'****

From which sky <<< DECLARE @edition sysname; ... came while it should be Update statement....

Please help