Sql server 超时死锁
saga_gallon
霓虹开满夜空,月光洒满心间
展开
-
SQLServer 2008数据库查看死锁、堵塞的SQL语句
--每秒死锁数量SELECT *FROM sys.dm_os_performance_countersWHERE counter_name LIKE 'Number of Deadlocksc%';--查询当前阻塞WITH CTE_SID ( BSID, SID, sql_handle ) AS ( SEL原创 2016-07-21 17:58:55 · 5450 阅读 · 0 评论 -
查看sqlserver数据库当前死锁
--死锁检测use masterSelect * from sysprocesses where blocked<>0--找到SPID exec sp_lock--根据SPID找到OBJIDselect object_name(85575343)--根据OBJID找到表名原创 2016-09-08 00:25:48 · 7845 阅读 · 0 评论 -
sql server 查看表的死锁和Kill 死锁进程
查询出来select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT 杀死死锁进原创 2016-07-27 16:34:00 · 2633 阅读 · 0 评论