How to lookup to lock and blocking counters

use DynamicsAx_PRO
go

------查询lock 循环次数 （倒序）

exec usp_Find_Problems
go

-----杀死进程

kill 141
go

-----查看当前数据库运行情况，可以看到进程被锁状况。

sp_who2

go

---查看当前数据库死锁明细

sp_lock

go

--查看当前数据库进程死锁等待时间（倒序）

Select a.sid,a.spid,a.waittime from sys.sysprocesses a where blocked <> 0
order by  a.waittime desc
go

---

SELECT * FROM sys.dm_tran_locks;
go

SELECT * FROM sys.dm_exec_requests
WHERE blocking_session_id <> 0;
GO

SELECT session_id, wait_duration_ms, wait_type, blocking_session_id
FROM sys.dm_os_waiting_tasks
WHERE blocking_session_id <> 0
GO