syntaxhelp.com Your online cheat sheet!

Create a resource pool

-- Create a pool ressource with the default parameters
CREATE RESOURCE POOL pResource
WITH
(
 min_cpu_percent=0, 
 max_cpu_percent=100, 
 min_memory_percent=0, 
 max_memory_percent=100
);
GO

Alter the resource pool configuration

-- Alter a ressource pool with parameter min_cpu_percent = 50
-- Don't forget to reload the resource governor's configuration after !!
ALTER RESOURCE POOL pResource
WITH
(
 min_cpu_percent=50
);
GO