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.
Epsiode 96 Building Community Tools
Episode 95 Polybase
Episode 94 Qlik Technologies
Episode 93 Making Mistakes
Episode 92 SSDT
Episode 91 DBA Tools
Episode 90 Check DBCC
Episode 89 Lone DBA
Episode 88 SharePoint
Episode 86 TsqlT
Episode 85 2016 Speedbumps
Episode 84 MVP
Podcast 83 Data Visualizations
Episode 82 Indexes Part 2
Episode 81 Indexes Part 1
Episode 80 Containers
Episode 79 SSIS Catalog
Episode 78: Conversion to 2016
Episode 77: New Reporting Options
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast