Database

Identify blocking query and kill blocking_session_id in mssql server

Identify the blocking query by executing below SQL SELECTdb.name DBName,tl.request_session_id,wt.blocking_session_id,OBJECT_NAME(p.OBJECT_ID) BlockedObjectName,tl.resource_type,h1.TEXT AS RequestingText,h2.TEXT AS BlockingTest,tl.request_modeFROM sys.dm_tran_locks AS tlINNER JOIN sys.databases db ON db.database_id = tl.resource_database_idINNER …

Identify blocking query and kill blocking_session_id in mssql server Read More »