Using Query Store Hints to Optimize Memory Grants Improving Performance | Data Exposed

From the creator

Query store hints enables changing query plan shapes without modifying application code. In this episode of Data Exposed with Denzil Ribeiro, we will look at an example of improving the performance of bulk loading data using query store hints. 0:00 Show begins 0:30 Introduction Denzil Ribeiro 1:40 Memory Grants Overview 2:49 Demo 13:05 Getting Started ✔️Resources: Performance impact of memory grants on data loads into Columnstore tables: https://techcommunity.microsoft.com/t5/datacat/performance-impact-of-memory-grants-on-data-loads-into/ba-p/305462 📌 Let's connect: Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna Twitter: Denzil Ribero, https://twitter.com/DenzilRibeiro Twitter: AzureSQL, https://aka.ms/azuresqltw 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer #QueryStoreHints #Hyperscale

Published 2021-09-09 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.