Know What Sessions Were Assigned to Each Workload Groups
You can use the following query to find out the name of the workload group
and the resource pool, in Resource Governor, that the classifier function
assigned each session of a Microsoft SQL Server Instance.
SELECTsession_id as 'Session ID',
[host_name] as 'Host Name',
[program_name] as 'Program Name',
nt_user_name as 'User Name',
SDRGWG.[Name] as 'Group Assigned',
DRGRP.[name] as 'Pool Assigned'
FROM sys.dm_exec_sessions SDES
INNER JOIN sys.dm_resource_governor_workload_groups SDRGWG
ON SDES.group_id = SDRGWG.group_id
INNER JOIN sys.dm_resource_governor_resource_pools DRGRP
ON SDRGWG.pool_id = DRGRP.pool_id
.Send mail to
questions or comments about this web site.