SqlServer如何查看死锁的进程

bubuko 2022/1/25 19:07:04 sqlserver 字数 4714 阅读 957 0 来源 http://www.bubuko.com/infolist-5-1.html

查看当前死锁 SELECT request_session_id spid, OBJECT_NAME( resource_associated_entity_id ) tableName FROM sys.dm_tran_locks WHERE resource_type = 'OBJECT' 查看 ...

查看当前死锁

SELECT
    request_session_id spid,
    OBJECT_NAME(
        resource_associated_entity_id
    ) tableName
FROM
    sys.dm_tran_locks
WHERE
    resource_type = ‘OBJECT‘

查看死锁进程

SELECT * FROM sys.dm_exec_connections;
SELECT * FROM sys.dm_exec_sessions;

SELECT spid
, blocked
, DB_NAME (sp.dbid) AS DBName
, program_name
, waitresource
, lastwaittype
, sp.loginame
, sp.hostname
, a.[Text] AS [TextData]
, SUBSTRING (A. TEXT, sp.stmt_start / 2, (CASE WHEN sp.stmt_end = -1 THEN DATALENGTH (A. TEXT) ELSE sp.stmt_end END - sp.stmt_start) / 2) AS [current_cmd]
FROM sys.sysprocesses AS sp
OUTER APPLY sys.dm_exec_sql_text (sp.sql_handle) AS A
WHERE spid > 50
ORDER BY blocked DESC, DB_NAME (sp.dbid) ASC, a.[text]

杀掉死锁进程

kill spid

SqlServer如何查看死锁的进程

原文：https://www.cnblogs.com/juices/p/14779498.html

如果您也喜欢它,动动您的小指点个赞吧

除非注明，文章均由 laddyq.com 整理发布，欢迎转载。

转载请注明：
链接：http://laddyq.com
来源：laddyq.com
著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。

SqlServer如何查看死锁的进程

分类汇总

您的鼓励是对我最大的支持