You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Anthony edited this page Jan 15, 2025
·
1 revision
BEGIN
PRINT '====================================================================='
PRINT 'show the blocked process record. '
PRINT '====================================================================='
GO
SELECT
*
FROM
[sys].[dm_exec_requests]
CROSS APPLY [sys].[dm_exec_sql_text]([sql_handle])
WHERE
1=1
AND blocking_session_id != 0;
USE [master];
GO
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'sp_WhoIsActive')
EXEC sp_WhoIsActive
@find_block_leaders = 1,
@get_plans = 1,
@sort_order = '[blocked_session_count] DESC';
GO
PRINT '====================================================================='
PRINT 'remove the blocked process. '
PRINT '====================================================================='
GO
--KILL 212;
END