Monday, July 19, 2010

Locks in SQL 2005

SELECT
request_session_id AS spid,
resource_type AS restype,
resource_database_id AS dbid,
resource_description AS res,
resource_associated_entity_id AS resid,
request_mode AS mode,
request_status AS status
FROM sys.dm_tran_locks;

SELECT * FROM sys.dm_exec_connections
WHERE session_id IN(56,57);

SELECT * FROM sys.dm_exec_requests
WHERE blocking_session_id > 0;


SELECT session_id, text
FROM sys.dm_exec_connections
CROSS APPLY sys.dm_exec_sql_text(most_recent_sql_handle) AS ST
WHERE session_id IN(56,57);

No comments:

Post a Comment