SQL Server Performance Tuning and Optimization

SQH05 Dealing with Bad Roommates - SQL Server Resource Governor


9:30am - 10:45am

Level: Intermediate to Advanced

Do you manage systems with a wide variety or workloads? Given budgeting and licensing constraints, database servers have seen dramatic amounts of database consolidation. Managing performance in densely consolidated environments is always a challenge. You have some users who are trying to run reports, while you have other uses that are trying to execute OLTP workloads. What if there was a way to do load balancing between these workloads, while putting your feet up on your desk? There is and it's called the Resource Governor. The Resource Governor was introduced in SQL Server 2008, and has progressively improved since then. New features include SQL Server 2014 so you can limit I/O use. In this session, you'll learn how the Resource Governor works, as well as best practices and use cases. You'll learn how to profile your workloads and keep your users and applications happy.

You will learn:

  • Understanding of use cases for the resource governor
  • How to implement the resource governor to manage disparate workloads in a converged SQL Server environment
  • How to manage runaway IO workloads with Resource Governor in SQL Server 2014