随笔分类 -  SqlServer 性能优化

摘要：死锁查询语句 1 WITH CTE_SID ( BSID, SID, sql_handle ) 2 AS ( SELECT blocking_session_id , 3 session_id , 4 ... 阅读全文

摘要：一 : 查看死锁以及数据表阻塞信息 1 CREATE procedure sp_who_lock 2 as 3 begin 4 declare @spid int 5 declare @blk int 6 declare @count int 7 declare @index int ... 阅读全文