SQL Server

[MSSQL] 1. 현재 진행 중인 Session 및 SQL 조회

푸팟퐁쿼리 2023. 4. 14. 11:41
SELECT 
   sqltext.TEXT,
   req.session_id,
   req.status,
   req.command,
   req.cpu_time,
   req.total_elapsed_time,
   DB_NAME(database_id) AS dbName
FROM sys.dm_exec_requests req
	CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext