Thursday 5 March 2015

Current user requests, their waits & text of SQL batch - DMOs

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