728x90

목록2021/07/05 (1)

DBILITY

mssql lock확인

EXEC SP_LOCK Mode가 X(Exclusive Lock)인 경우 SPID를 확인 DBCC INPUTBUFFER(SPID) Client의 마지막 statement를 표시 EXEC SP_WHO SPID STATUS, LOINGNAME, DBNAME등 SPID정보를 출력 KILL SPID SPID에 해당하는 프로세스를 종료 #ACTIVE SESSION QUERY SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext; #LOCK ..
database/mssql 2021. 7. 5. 14:29
Prev 1 Next
728x90