SQL Server 查看被锁住的语句

查看被锁语句及引起锁的语句：

SELECT
	t1.resource_type [资源锁定类型],
	DB_NAME(resource_database_id) AS 数据库名,
	t1.resource_associated_entity_id 锁定对象,
	t1.request_mode AS 等待者请求的锁定模式,
	t1.request_session_id 等待者SID,
	t2.wait_duration_ms 等待时间,
	(
		SELECT
			TEXT
		FROM
			sys.dm_exec_requests r CROSS apply sys.dm_exec_sql_text (r.sql_handle)
		WHERE
			r.session_id = t1.request_session_id
	) AS 等待者要执行的SQL,
	t2.blocking_session_id [锁定者SID],
	(
		SELECT
			TEXT
		FROM
			sys.sysprocesses p CROSS apply sys.dm_exec_sql_text (p.sql_handle)
		WHERE
			p.spid = t2.blocking_session_id
	) 锁定者执行语句
FROM
	sys.dm_tran_locks t1,
	sys.dm_os_waiting_tasks t2
WHERE
	t1.lock_owner_address = t2.resource_address