Past Meetup

[DBD] Understanding SQL Server Memory and Memory Grants

This Meetup is past

29 people went

What we'll do

Memory is critical to SQL Server performance. Both to cache data and to run queries. A commonly forgotten, if not unknown, and poorly understood aspect of performance is "memory grants".

This session will examine the different memory regions that SQL Server's database engine uses for various caches, focusing on the one that is very important for query performance. We’ll walk through basic memory configuration changes introduced in SQL Server 2012 and how they differ from earlier versions

Furthermore, we’ll get a bit deeper into memory allocations for query needs and see what happens under the hood. Although many things are managed internally, and you can’t influence them, they mostly run well out-of-the-box. This session's goal however, is to put you in control and give you the knowledge and tools to help you maximize query performance.

Agenda:

• 12:00 - 12:10: Networking / "Gossip"

• 12:10 - 12:20: Vendor session

• 12:20 - 14:00: Main session

Speaker: Stanislav Smoltis
Stan is a SQL Server Developer with experience of building and administering enterprise-scale data solutions on both cloud and on-premise environments. He is currently responsible for development and query tuning for a high-performance, 24x7 OLTP database solution. He has worked with SQL Server since 2004 and spent the last 3 years as a consulting engineer advising various companies on SQL Server infrastructure design and performance aspects.