Skip to content

Instantly share code, notes, and snippets.

@ghotz
Created March 20, 2015 12:28
Show Gist options
  • Save ghotz/143e24d5b68f86de5506 to your computer and use it in GitHub Desktop.
Save ghotz/143e24d5b68f86de5506 to your computer and use it in GitHub Desktop.
Quick Check Resource Governor
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