You’re only 3 weeks away from a new language
NY State-Licensed Certificates in Design, Coding & AI — Online
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