SDL 当前连接查询脚本

USE [EIP.SurveyOnline2019]


-- 查看当前数据库连接
SELECT * from master.dbo.sysprocesses
where dbid = DB_ID(‘EIP.SurveyOnline2019‘)


-- 查看当前活动事务
DBCC OPENTRAN


--查询死锁
select    
    request_session_id spid,   
    OBJECT_NAME(resource_associated_entity_id) tableName    
from    
    sys.dm_tran_locks   
where    
    resource_type=‘OBJECT‘ 


--杀死死锁进程
kill 354 


--显示死锁相关信息
exec sp_who2 75


-- 查看所有会话的状态、等待类型及当前正在执行SQL脚本
select t.spid, t.kpid, t.blocked, t.status, t.waittype, t.lastwaittype, t.waitresource, t.waittime
    , DB_NAME(t.dbid) DbName, t.login_time, t.last_batch, t.loginame, t.program_name, t.hostname, t.hostprocess
    , t.cmd, t.stmt_start, t.stmt_end, t.request_id, dc.text
from    master.sys.sysprocesses t
    outer apply master.sys.dm_exec_sql_text(t.sql_handle) dc
where    t.spid >= 50 AND dc.dbid = 42