tubeshowcase●1,673,858 videos♡ My collection 0
← Learn to Code

Learn to Code16:20

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

Microsoft Developer ↗

From the creator

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. 0:00 Introduction 1:04 What is a memory grant? 2:36 When can memory grants become a problem? 4:37 The troubleshooting process 5:48 Demo 14:54 Summary 15:26 Learn more Resources: For the full Azure SQL for beginners Special Edition series on Performance Troubleshooting, watch: https://aka.ms/performanceseries For the full Azure SQL for beginners series, watch: https://aka.ms/azuresql4beginners Learn more about SQL memory grants: https://aka.ms/sqlmemorygrant Azure SQL Workshop​: https://aka.ms/azuresqlworkshop Azure SQL Fundamentals​: https://aka.ms/azuresqlfundamentals Watch Data Exposed​: https://aka.ms/dataexposed See more videos from our team​: https://aka.ms/azuresqlyt Follow us on social media​: https://aka.ms/azuresqltwitter Read the books: https://aka.ms/azuresqlbook, https://aka.ms/azuresqlfordevelopers

Published 2023-02-08 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.

Keep exploring Learn to Code