Why do some features get all the fun? I would like to be a fly on the wall at some of the Microsoft feature development meetings. There are many very cool features that didn't get quite enough love to get the adoption they deserve. In this episode we are talking about Resource Governor and before you roll your eyes, you may be interested to know some of the side benefits of using the feature. We are joined by Mark Wilkinson from channeladvisor to give us an overview of the feature and how they use it to manage SQL resources and workloads.
One interesting story is how their team won the query challenge last PASS summit using Resource Governor so it is pretty powerful. Mark will also share his experiences using Resource Governor in different working environments. He will also be discussing the basics and tips about building the classifier function of Resource Governor. Furthermore, we will go through setting up I/O caps, resource pools and workloads, and the NUMA node affinity.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/02/08/episode-87-resource-governor/ and have fun on the SQL trail.