SELECT S.login_name,
S.host_name,
S.program_name,
R.command,
T.text,
R.wait_type,
R.wait_time,
R.blocking_session_id
FROM sys.dm_exec_requests AS R
INNER JOIN sys.dm_exec_sessions AS S
ON R.session_id = S.session_id
OUTER APPLY sys.dm_exec_sql_text(R.sql_handle) AS T
WHERE S.is_user_process = 1;
//returns current requests their waits and text of their SQL batch
No comments:
Post a Comment