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
반응형