SQL数据库进程阻塞导致客户端无法插入数据

use master
go
--查看当前阻塞进程ID
SELECT blocking_session_id '阻塞进程的ID', wait_duration_ms '等待时间(毫秒)', session_id '(会话ID)' FROM sys.dm_os_waiting_tasks
go
kill  "进程ID"
go

use master
go
--检索死锁进程
select spid, blocked, loginame, last_batch, status, cmd, hostname, program_name
from sysprocesses
where spid in
( select blocked from sysprocesses where blocked <> 0 ) or (blocked <>0)

----通过数据库日志查看连接客户端
xp_readerrorlog