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

1 comment:

  1. the article, and more importantly, your personal experienceMindfully using our emotions as data about our inner state and knowing when it’s better to de-escalate by taking a time out are great tools. Appreciate you reading and sharing your story, since I can certainly relate and I think others can too
    https://vidmate.onl/download/

    ReplyDelete