Resource Governor Fundamentals

Microsoft in the News

If you are like me, you love using your Microsoft Surface. I know many of you who use a surface at work and have your own for home. Some of you even have a Surface Laptop. For those of you who would like to extend the pleasure of using these devices to others in the family who are in less need of computing power, there is the Surface Go.

This was launched last year and I missed it, so I thought I’d mention it in case others missed it as well. At less than half the price of a Surface, the Go provides everything the average student or home user needs in a very portable package.

You can find the shiny brochure here:

https://www.microsoft.com/en-ca/p/surface-go/8v9dp4lnknsz/l8m8?activetab=pivot%3aoverviewtab

Resource Governor Fundamentals

It is always good policy to understand what you are doing before you do it. With that in mind, I want to review a few concepts that are fundamental to understanding how you will use SQL Server Resource Governor (“Resource Governor”). There are three concepts I want to review:

  1. Resource Pools,
  2. Workload Groups, and
  3. Classification.

A Resource Pool refers to the CPU, physical IO and memory that are available to SQL Server. When you install SQL Server, you have two resource pools: internal and default. By using Resource Governor, you are able to define a third resource pool that can be used to ensure jobs are not tripping over each other in search of resources. Within Resource Governor you can create resource pools that are subsets of the whole.

A Workload Group is a container for session requests that fit within a specified classification criterion. By defining Workload Groups, you are able to allocate defined Resource Pools to them and monitor each session independently.

Resource Governor allows you to define classifications for incoming sessions. You write a classifier function that will automatically assign a session to a defined Workload Group. The classification is based on the characteristics of the session that you supply to the function.

Visually, here is how it works:

Each Defined Group can be allocated a specified resource pool. Each Defined Resource Pool will have express limits assigned to it.

In my next blog I will show you how to set up SQL Server Resource Governor.

Leave a Reply

Your email address will not be published. Required fields are marked *

X