Resource Governor – Getting Started

Microsoft in the News

Gates Notes

In case you missed it, back in December, Bill gates put out a newsletter with a list of five books he loved in 2018. They included:

  • Educated, by Tara Westover,
  • Army of None, by Paul Scharre,
  • Bad Blood, by John Carreyrou,
  • 21 Lessons for the 21st Century, by Yuval Noah Harari, and
  • The Headspace Guide to Meditation and Mindfulness by Andy Puddicombe.

Like most successful people, Mr. Gates is a voracious reader. He seems to read mostly non-fiction, but I have found a few wonderful fiction books in his list as well (The Rosie Project immediately comes to mind). Not only does he recommend books, but he often reviews them and tells you why it might be important.

In addition to his reading list, his blog contains posts about a wide variety of topics. I would encourage everyone to check out his blog at:

Resource Governor – Getting Started

In my previous blogs I have outlined the fundamentals of the SQL Server Resource Governor. I have shown what it can do and why you might want to use it. In this blog I will start the process of how to set it up.

Resource Governor can be found under the Management folder in SQL Server Management Studio. By default, Resource Governor is turned off. Before you toggle that switch, you can configure it to suit your specific needs.

Before you get started, you must have Control Server permission. If you have that, then you can proceed by right-clicking on the Resource Governor icon, you can choose New Resource Pool…

A dialogue box will open and there is a check box that will Enable Resource Governor.

Some rules you must follow when configuring Resource:

  • When allocating maximum percentages for CPU or Memory, those allocation must be greater than the minimum percentage allocations for CPU or Memory respectively.
  • When allocating the minimum percentages for CPU or Memory, the total allocation for each must not exceed 100%.

It is also handy to script out your settings to either save for version control or to reuse at a later time.  By right-clicking, you can choose Properties. This will also take you to the Resource Pools grid. Choose the first column (labelled “*”)  

Note: if you don’t see this remember to click, enable resource governor then it will show up. 

Double click the empty cell in the Name column. Name your resource pool with something meaningful for future reference.

Change any other cell you want while adhering to the configuring rules above. Save your work by clicking the OK button.

My next blog will cover changing or deleting a resource pool.

Leave a Reply

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