SQL Server handy scripts

SQL Server handy scripts.sql

-- Check the BlkBy column
EXEC sp_who2

-- Get all requests that have blocking sessions
SELECT *
FROM sys.dm_exec_requests
WHERE DB_NAME(database_id) = 'YourDBName'
AND blocking_session_id <> 0

-- Get the queries themselves
SELECT text,*
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle)
WHERE DB_NAME(database_id) = 'YourDBName'
AND blocking_session_id <> 0

-- If there are any transaction blocked, check the following table
SELECT *
FROM sys.dm_tran_session_transactions