System Story/Database

MSSQL 현재 수행중인 쿼리 확인

helperchoi 2013. 11. 10. 23:33

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

반응형