Advertisement
Guest User

Untitled

a guest
Feb 6th, 2016
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. CREATE TABLE [dbo].[Table_1]( [Test] [int] NULL)
  2.  
  3. sp_configure'block process threshold', 1 --> 1 sec
  4. go
  5.  
  6. Begin tran
  7. Update [dbo].[Table_1]
  8. set [Test]=1
  9.  
  10. select * from [dbo].[Table_1]
  11.  
  12. <blocked-process-report monitorLoop="1670">
  13. <blocked-process>
  14. <process id="process1f18028c8" .......>
  15. <executionStack>
  16. <frame line="1" stmtend="56" sqlhandle="0x02000000c7f1523220ed350bb649a019ae7dc2bca448a2000000000000000000000000000000000000000000" />
  17. </executionStack>
  18. <inputbuf>
  19. select * from [dbo].[Table_1]
  20. </inputbuf>
  21. </process>
  22. </blocked-process>
  23. <blocking-process>
  24. <process status="sleeping" spid="59"....>
  25. <executionStack />
  26. <inputbuf>
  27. **DECLARE @edition sysname; SET @edition = cast(SERVERPROPERTY(N'EDITION') as sysname); select case when @edition =
  28. N'SQL Azure' then 2 else 1 end as 'DatabaseEngineType'**** </inputbuf>
  29. </process>
  30. </blocking-process>
  31. </blocked-process-report>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement