Triad SQL Server User Group

The Triad SQL Server Users Group (TSSUG); is a forum where Microsoft SQL Server database administrators and developers meet to learn more about the product, share ideas and make contact with other similar individuals. Our group is run by SQL Server professionals for the benefit of anyone interested in participating in the group.
All of our meetings are free and open to anyone who is interested in sharing their knowledge of SQL Server. Our meetings are generally held on the last Tuesday of every other month, unless otherwise noted. Food is no longer being provided, however you are welcome to bring in your own.


Next Meeting: Tue, May 23 2017

Brian Carrig Presents The SQL Server Resource Governor

Language: English
Event Type: In-Person
Online Meeting URL: None

Bi-Monthly Meeting


UTC : Tue, May 23 2017 22:00 - 00:00
Event Time : Tue, May 23 2017 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Tue, May 23 2017 22:00 - 00:00


4821 Koger Blvd
Greensboro, North Carolina

Direction: None

Featured Presentation

SQL Server Resource Governor

Speaker: Brian Carrig, Senior Program Manager Microsoft

Summary: The SQL Server Resource Governor feature is an incredibly useful tool for any DBA to have in their toolbox. It allows for the effective throttling and control of resources consumed by multiple workloads running on a single SQL Server instance. In this session, we will cover the fundamental concepts of resource governor and provide demonstrations of practical scenarios where resource governor can be used to control resources for specific workloads. Examples include how to limit the amount of memory consumed by in-memory OLTP tables and how to prevent poorly written queries from overwhelming your storage subsystem. We also discuss cases where resource governor can be used to limit parameter sniffing problems and ways to leverage the useful information contained in the resource governor DMVs for monitoring and reporting purposes.

About Brian: Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Senior Program Manager on the SQL Server Tiger Team at Microsoft focusing primarily on persistent memory technology and replication. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Redmond, Washington. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.








Back to Top