Oregon Data Community - August 20th - Azure SQL Memory Grants!
Details
Welcome to the August 20th 1800 HRS PST/2100 HRS EST/0200 HRS CEST, 2025 HYBRID meeting!
We are once again meeting in person in Vancouver, WA at the downtown Umpqua Bank in their Community Room!
We meet on the 3rd Wednesday of the month once again at 6:00 PM PST. We will have snacks and networking before the main meeting
We believe we have found a new location – fingers crossed!
Meetup Link:
https://www.meetup.com/oregonsql/events/308930951
In order to encourage questions during the presentation, please use chat which will be monitored and/or use the raise hands option in Teams. Please be mindful of the other attendees and mute your mic!
We will be starting at 6:00 PM PST/9:00 PM EST
Schedule: (may be fluid due to discussions and Q/A):
6:00 – 6:30 PM – Snacks/Announcements/Networking
6:30 PM – Presentation
8:30 PM – Happy Hour/Networking (Shanahans in Vancouver)
Presentation:
Title: Azure SQL Memory GrantsAbstract:
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.
Oregon Data Community - August 20th - Azure SQL Memory Grants!