Confused by sp_who2 (Dear SQL DBA Episode 30)

preview_player
Показать описание
Learn why the output for the built in sp_who2 can be confusing, and better tools to get you more information, fast.
Note: technical content begins about a minute into the video.
Рекомендации по теме
Комментарии
Автор

Dbcc inputbuffer(SPID) - TO GET INFORMATION ABOUT PROCESS HANGING

DBCC OPENTRAN - TO CHECK OLD TRANSACTION IN DB

Aparichitha
Автор

Thanks Kendra for the nice explanation :)
: Dev

sqlgeekspro