How to Create Resource Pool in Resource Governor of SQL Server - SQL Server DBA Tutorial

In this video you will learn how to create Resource Pool in Resource Governor of SQL Server using SQL Server Management studio as well as using T-SQL script. It demonstrates application of Resource Pool best practices, when to create resource pool, step by step process of creating resource pools for different application, configuring Physical resources of SQL Server such as CPU, Memory and Physical IO.

Script to Create Resource Pool in Resource Governor in SQL Server

CREATE RESOURCE POOL [ReportQueries] WITH(min_cpu_percent=0,
        max_cpu_percent=50,
        min_memory_percent=0,
        max_memory_percent=50,
        AFFINITY SCHEDULER = AUTO
)
GO

CREATE RESOURCE POOL [FinanceApp] WITH(min_cpu_percent=0,
        max_cpu_percent=25,
        min_memory_percent=0,
        max_memory_percent=40,
        AFFINITY SCHEDULER = AUTO
)
GO

ALTER RESOURCE GOVERNOR RECONFIGURE;
GO

 Create Resource Pool in Resource Governor of SQL Server - SQL Server DBA Tutorial

No comments:

Post a Comment