Episode

Waiting due to memory grants [7 of 7] | Azure SQL for beginners

with Bob Ward

Azure SQL for Beginners

In this episode we will look at another common performance problem due to waiting on resources related to memory grants. This scenario involves a problem where some CPU is observed for slow performance but also many waits are seen for a resource related to a memory grant for a query. We will look more behind what is a memory grant and why certain query patterns or design can result in memory grants that lead to performance problems.

Chapters

  • 00:00 - Introduction
  • 01:04 - What is a memory grant?
  • 02:36 - When can memory grants become a problem?
  • 04:37 - The troubleshooting process
  • 05:48 - Demo
  • 14:54 - Summary
  • 15:26 - Learn more

Azure
Azure SQL Database