A Little About Memory Grants In SQL Server Query Plans
Vložit
- čas přidán 6. 09. 2024
- Become a member! / @erikdarlingdata If you like what you see here, you'll love my advanced performance tuning training:
training.erikd... Click here for 50% off a health check: training.erikd...
Useful video!thank you!
Usefulness is next to cleanliness, or something.
"Thumbs are fingers, hot dogs are sandwiches"; lol; I watch for the quality content, and stay for the entertainment
Oysters are nachos.
Great video Erik. The dreaded 'put everything into large varchar fields' antipattern rarely mentions the memory issue even though it can have pretty dire consequences as you prove. QQ for you though .... how much memory would be allocated to a varchar(max) and nvarchar(max) field? Also, which is the best field in the Actual Execution Plan to ascertain how much memory was actually needed for the data (ie. to see how much the plan actually wasted)?
The grant for max fields is still about half. It’s estimated size of data. The best place to see memory grant details in actual plans is in the memory grant property of the root node.