Memory Management | SQL Server :- Memory Grant Info (5/15)
In this video we cover the Memory grant info available in the Query execution plan. We understand the different between required and desired memory. How the Max degree of parallelism affects the amount of memory that is granted. We also cover what a tempdb spill looks like from a memory grant point of view.
The video explains different steps involved in requesting memory from the SQL OS.
Need more information?
Visit https://www.enabledbusinesssolutions.com
To know more about Jayanth Kurup visit https://www.jayanthkurup.com
Jayanth is a Microsoft SQL Server trainer / consultant with over 18 years experience. He has worked with companies like Microsoft, IBM, HCL , Wipro , WellFargo , Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community.
In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc.
You can also reach Jayanth via his LinkedIn profile below
/ jayanth-kurup