Lock Pages in Memory Part 2/15
In this video we start off by explaining the very first action a DBA performs with respect to memory. Granting lock pages in memory is a permission SQL Server needs to be prevent windows from paging out data SQL Server has placed in the RAM. This ensures that SQL Server will always find its data pages in the memory. This significantly improves performance.
Memory is a core component of SQL Server Performance. Understanding how it works is critical to a good user experience, it is also among most difficult areas to troubleshoot. Unlike CPU or Disk there aren't many options available to fine tune it either. In this video series we begin an in-depth analysis of how memory works in SQL Server. We start off with some basic concepts and ramp our self up as we dive deeper.
Want to know more SQL Server stuff?
Need more information?
Visit https://www.enabledbusinesssolutions.com
To know more about Jayanth Kurup visit http://www.jayanthkurup.com
Jayanth is a Microsoft SQL Server trainer / consultant with over 15 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 reach Jayanth on
/ jayanth-kurup