Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE [dbo].[Table_1]( [Test] [int] NULL)
- sp_configure'block process threshold', 1 --> 1 sec
- go
- Begin tran
- Update [dbo].[Table_1]
- set [Test]=1
- select * from [dbo].[Table_1]
- <blocked-process-report monitorLoop="1670">
- <blocked-process>
- <process id="process1f18028c8" .......>
- <executionStack>
- <frame line="1" stmtend="56" sqlhandle="0x02000000c7f1523220ed350bb649a019ae7dc2bca448a2000000000000000000000000000000000000000000" />
- </executionStack>
- <inputbuf>
- select * from [dbo].[Table_1]
- </inputbuf>
- </process>
- </blocked-process>
- <blocking-process>
- <process status="sleeping" spid="59"....>
- <executionStack />
- <inputbuf>
- **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'**** </inputbuf>
- </process>
- </blocking-process>
- </blocked-process-report>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement