CREATE VIEW dbo.RGObjects_Runtime AS SELECT p.pool_id, PoolName = p.name, g.group_id, GroupName = g.name FROM sys.dm_resource_governor_resource_pools AS p LEFT OUTER JOIN sys.dm_resource_governor_workload_groups AS g ON p.pool_id = g.pool_id; GO
CREATE VIEW dbo.RGObjects_Runtime AS SELECT p.pool_id, PoolName = p.name, g.group_id, GroupName = g.name FROM sys.dm_resource_governor_resource_pools AS p LEFT OUTER JOIN sys.dm_resource_governor_workload_groups AS g ON p.pool_id = g.pool_id; GO