Resource Governor allows you to manage SQL Server workloads and resources on incoming requests. This allows you  to provide predictable performance for different workloads on a single instance.  It also allows you to track resource utilization for your different applications or workloads. This session will give you an introduction to resource governor concepts and components. I will walk you through configuring and implementing resource governor.  You will see how you can use resource governor to not only limit resource consumption by a particular application or workload but also how to track resource utilization for chargeback to a particular department or division. Resource governor is an underutilized feature in SQL Server so come learn more about it and how it can help provide a consistent experience for you!

Sherwin Anderson is a Microsoft Certified Master.  He has worked with SQL Server for over 15 years.  He currently works for Microsoft as a Premier Field Engineer specializing in performance tuning, optimization, high availability,  as well as APS/PDW.   When he is not working you can generally find him officiating lacrosse around the state of Florida