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

In this video you will learn how to create Workload in Resource Governor of SQL Server using SQL Server Management Studio as well as using T-SQL script. It also illustrates how to configure the importance, timeout settings and DOP (Degree of Parallelism) of a workload. It also shows how to assign workload to an existing resource pool.

Script to Create WorkLoad  Group in Resource Governor of SQL Server

USE [master]

GO

/****** Object:  WorkloadGroup [ExcelQueries]    ******/
CREATE WORKLOAD GROUP [ExcelQueries] WITH(group_max_requests=20,
        importance=Medium,
        request_max_cpu_time_sec=1000,
        request_max_memory_grant_percent=25,
        request_memory_grant_timeout_sec=1000,
        max_dop=4) USING [FinanceApp]
GO

USE [master]

GO

/****** Object:  WorkloadGroup [ReportQueriesWG]  ******/
CREATE WORKLOAD GROUP [ReportQueriesWG] WITH(group_max_requests=30,
        importance=Medium,
        request_max_cpu_time_sec=2000,
        request_max_memory_grant_percent=40,
        request_memory_grant_timeout_sec=1000,
        max_dop=6) USING [ReportQueries]
GO 

Create WorkLoad  Group in Resource Governor of SQL Server - SQL Server DBA Tutorial