查看数据库阻塞

--创建递归查询数据库的阻塞
WITH CTE_TABLE(session_id,wait_type,blocking_session_id,resource_type,DATABASE_NAME,resource_lock_partition,request_mode,request_type,request_status,LV)
AS
(
SELECT
 A.session_id,
 A.wait_type,
 A.blocking_session_id,
 B.resource_type,
 DB_NAME(B.resource_database_id) AS DATABASE_NAME,
 B.resource_lock_partition,
 B.request_mode,
 request_type,
 B.request_status,
 1
FROM SYS.dm_os_waiting_tasks A
JOIN SYS.dm_tran_locks B ON A.resource_address=B.lock_owner_address
WHERE session_id>50
UNION ALL
SELECT
 C.session_id,
 C.wait_type,
 C.blocking_session_id,
 C.resource_type,
 C.DATABASE_NAME,
 C.resource_lock_partition,
 C.request_mode,
 C.request_type,
 C.request_status,
 CTE_TABLE.LV+1
FROM
 (
  SELECT
   A.session_id,
   A.wait_type,
   A.bloc