Memory Grant in Azure SQL
When SQL Server executes a query, it requires memory to store temporary data for sorting and joining rows. In this deep dive session, you will learn about the intricacies of memory grants, including how they are requested, allocated, and used during query execution. You will explore the dependencies of memory grants and the impact of insufficient memory leading to spills to tempdb, which can degrade performance. The session will also cover the memory grant feedback feature introduced in SQL Server 2019, explaining how it dynamically adjusts memory grants based on historical query execution data. Finally, you will gain insights into identifying and optimizing memory-intensive queries to enhance overall throughput and reduce costs by effectively scaling down the Azure SQL database. This session aims to equip you with a thorough understanding of memory management in SQL Server and practical techniques to improve query performance.
Bio
Torsten (MVP, MCSE, MCT) has been deeply involved with Microsoft SQL Server since the early 2000s, specializing in optimizing performance for extensive SQL Server environments. He has dedicated over two decades to working with bp as a platform engineer and collaborates closely with Sarpedon Quality Lab in his role as Principal Microsoft SQL Server Consultant.
Torsten has delivered more than 300 presentations on SQL Server performance optimization and Azure DevOps at various national and international conferences and user groups. Since 2018, he has been recognized as a Microsoft Most Valuable Professional for Data Platform. Moreover, for three consecutive years, Sessionize has acknowledged him as one of the most active speakers.
Oregon Data Community 
Leave a comment