Tutorial by Examples

select * from sys.dm_resource_governor_workload_groups select * from sys.dm_resource_governor_resource_pools

First create a resource pool besides the default one CREATE RESOURCE POOL [PoolAdhoc] WITH(min_cpu_percent=0, max_cpu_percent=50, min_memory_percent=0, max_memory_percent=50) GO Create the worload group for the pool CREATE WORKLOAD GROUP [AdhocMedium] WITH(importa...