So, I’m presenting a session at SQL Saturday Chicago on March 23, 2019. This is a new session, called Performance tuning with SQL Server memory grants.
Blogging about writing a presentation
I’m going to write a couple blog posts as I write this session and practice for it. I hope this is interesting to read.
Tomorrow, I’ll brain dump all my ideas into a blog post.
Here’s the session abstract
When you’re performance tuning queries with memory grants, you want to know where, how and why the memory is granted and used in your query.
In this session, we’ll talk about analyzing requested and granted memory inside execution plans, the plan cache, and in currently running queries.
We’ll also talk about troubleshooting your system when many queries have memory grants.
Prerequisites: General knowledge of execution plans and query writing