Gasire blocaje pe un server MSSQL Server

Configurare noua (How To)

Situatie

Mai jos este o procedura care listeaza eventualele blocaje de pe un server MSSQL Server.

Solutie

create procedure FindBlockingProcesses

as

SELECT
blocking_session_id AS BlockingSessionID,
session_id AS VictimSessionID,
(SELECT text FROM sys.dm_exec_sql_text(sql_handle)) AS SQLQuery
FROM sys.dm_exec_requests
WHERE blocking_session_id > 0

Tip solutie

Permanent
Etichetare:

Voteaza

Up Down
(2 din 4 persoane apreciaza acest articol)
Share
Tweet
Share

Despre Autor

Leave A Comment?