DBA vs. Memory Settings
SQL Server memory pressure: What is it and how does it affect SQL Server?
In this slide deck, renowned SQL Server experts Kendra Little and Jason Hall will play around with various configurations of Max Server Memory, Min Server Memory and Lock Pages in Memory and watch SQL Server squirm – for science! You’ll come away with a fresh understanding of how to configure major memory settings for SQL Server.
You'll learn:
- Monitor available memory for the OS.
- Monitor target/total memory of SQL Server historically.
- And more