sqlserver查询阻塞进程及阻塞的语句

select t1.blocked as '阻塞的进程id',
    OBJECT_NAME(t2.resource_associated_entity_id) as '阻塞的表',
    t3.hostname as '阻塞进程-hostname',
    t3.nt_domain as '阻塞进程-nt_domain',
    t3.nt_username as '阻塞进程-nt_username',
    t3.loginame as '阻塞进程-loginame'
from master..sysprocesses t1
inner join sys.dm_tran_locks t2 on t1.blocked = t2.request_session_id and t2.resource_type = 'OBJECT'
inner join master..sysprocesses t3 on t1.blocked = t3.spid
where t1.blocked > 0

根据阻塞进程id查询阻塞代码

DBCC INPUTBUFFER (93)

杀死阻塞进程

kill 93

查询连接数

select * from master.dbo.sysprocesses