syntaxhelp.com Your online cheat sheet!

Create workload group

-- Create workload group with the different parameters
-- and using the resource pool pResource
CREATE WORKLOAD GROUP gWorkload
WITH
(
 IMPORTANCE = MEDIUM,
 REQUEST_MAX_MEMORY_GRANT_PERCENT = 50,
 MAX_DOP = 1,
 GROUP_MAX_REQUESTS = 10
)
USING pResource;
GO

Alter the workload group configuration

-- Alter the workload group with importance equal to LOW
-- Don't forget to reload the resource governor's configuration !!
ALTER WORKLOAD GROUP gReportingAccess
WITH
(
 IMPORTANCE = LOW
);
GO