Created
March 20, 2015 12:28
-
-
Save ghotz/143e24d5b68f86de5506 to your computer and use it in GitHub Desktop.
Quick Check Resource Governor
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT * FROM sys.dm_exec_query_resource_semaphores WHERE pool_id = 1 | |
SELECT S1.session_id, S1.[host_name], S1.[program_name], S1.login_name | |
, R1.command, R1.status, R1.wait_type, R1.wait_time, R1.last_wait_type, R1.wait_resource | |
, M1.* | |
FROM sys.dm_exec_sessions AS S1 | |
JOIN sys.dm_exec_requests AS R1 | |
ON S1.session_id = R1.session_id | |
LEFT | |
JOIN sys.dm_exec_query_memory_grants AS M1 | |
ON R1.session_id = M1.session_id | |
AND R1.request_id = M1.request_id | |
WHERE | |
S1.group_id = 1 AND S1.is_user_process = 1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment