Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Query Tuning Mastery - Zen and the Art of Workspace Memory

PASS Data Community Summit via YouTube

Start learning Write review
Babbel Ad

You’re only 3 weeks away from a new language

Learn More → Noble Desktop Ad

NY State-Licensed Certificates in Design, Coding & AI — Online

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course explains how SQL Server allocates workspace memory to complex queries and how memory grants affect performance and concurrency. It covers memory internals, monitoring techniques, and query hints for tuning grants.

Syllabus

Intro
Quick Warning
Agenda
Workspace Memory
Iterators
Memory
Shared Memory
Query Running
Resource Semaphore
Exception
Question
Monitoring
Verifying
Viewing the Memory Grant
Memory Fractions
Memory Grants
Query Memory Objects
Cue Timeouts
Recap
TempDB
HashMatch
Memory Allocation
Recursion
Sort
Exchange

Taught by

PASS Data Community Summit

Reviews

Start your review of Query Tuning Mastery - Zen and the Art of Workspace Memory

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.