01 2018 档案
sql查询死锁
摘要：--每秒死锁数量 SELECT * FROM sys.dm_os_performance_counters WHERE counter_name LIKE 'Number of Deadlocksc%'; --查询当前阻塞 WITH CTE_SID ( BSID, SID, sql_handle ) AS ( SELECT blocking_ses... 阅读全文
posted @ 2018-01-15 11:20 代码改变世界&1024 阅读(3577) 评论(0) 推荐(0)