SQLServer: 現在実行中クエリのリアルタイムトラブルシューティング - Qiita

SELECT TOP 100 der.session_id as spid ,der.blocking_session_id as blk_spid ,datediff(s, der.start_time, GETDATE()) as elapsed_sec ,DB_NAME(der.database_id) AS db_name ,des.host_name ,des.program_name ,der.status -- Status of the request. (background / running / runnable / sleeping / suspended) ,dest.text as command_text ,REPLACE(REPLACE(REPLACE(SUBSTRING(dest.text, (der.statement_start_offset / 2)

[peketamin]

感謝...!