Forum Topic

Thanks for your participation and contribution.


Back to Performance Tuing

Resource Governor Pool Configuration

i90runner1
i90runner1

Resource Governor Pool Configuration

Limit CPU and Memory usage on default resource pool

USE [master];
GO

SELECT * 
FROM  sys.resource_governor_resource_pools

USE [master];
GO

ALTER RESOURCE POOL [default] WITH
(
MAX_MEMORY_PERCENT = 90,
MAX_CPU_PERCENT = 85
)
go 

SELECT * 
FROM  sys.resource_governor_resource_pools
GO

ALTER RESOURCE GOVERNOR RECONFIGURE;  

References :
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/use-resource-governor-to-limit-cpu-usage-by-backup-compression-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15.

Last updated

1-1 of 1

Reply to this discussion

You cannot edit posts or make replies: You should be logged in before you can post.