Using Query Store Hints to Optimize Memory Grants, Improving Performance

Data Exposed - Channel 9

Content provided by Data Exposed - Channel 9. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Data Exposed - Channel 9 or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

2+ y ago 14:47

MP4•Episode home

Archived series ("Inactive feed" status)

When? This feed was archived on April 09, 2022 01:29 (2y ago). Last successful fetch was on March 08, 2022 12:18 (2y ago)

Why? Inactive feed status. Our servers were unable to retrieve a valid podcast feed for a sustained period.

What now? You might be able to find a more up-to-date version using the search function. This series will no longer be checked for updates. If you believe this to be in error, please check if the publisher's feed link below is valid and contact support to request the feed be restored or if you have any other concerns about this.

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.

[00:30] Introduction Denzil Ribeiro
[01:40] Memory Grants Overview
[02:49] Demo
[13:05] Getting Started

Resources:

Performance impact of memory grants on data loads into Columnstore tables

25 episodes

#Tech #SQL Server #montserrat #Video