SFSSUG – Manage SQL Workload and Resource Consumption with Resource Governor

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