April 26, 2018 6:30 PM

PacificSource Health Plans
13010 SW 68th Parkway, Suite 140
Tigard, OR 97223

As you are facing the long side of the building – the main entrance is to your left. To the right, around the corner at the end of the building is a door which leads to the hallway where the new room is, and the first door on your right is “it”.
DBA vs Memory Settings: Pressure Testing Max Server Memory and Locked Pages in Memory

Whether you're configuring a SQL Server in the cloud, on your laptop, or in a lab down the hallway from your desk, memory settings are critical. What happens to SQL Server when external memory pressure strikes? In this session we’ll push a SQL Server around with various configurations of Max Server Memory, Min Server Memory, and Locked Pages in Memory and watch it squirm -- for science! You’ll come away with a fresh understanding of how to configure major memory settings for SQL Server, including considerations for Virtual Machines and Failover Cluster Instances.

Kendra Little teaches database administrators and developers to performance tune SQL Server. She is a Microsoft Certified Master in SQL Server, a Microsoft MVP, and a fan of illustrating SQL Server internals with drawings of dinosaurs and the poop emoji. For a fun weekly challenge, sign up for Kendra's free Quizletter at SQLWorkbooks.com



PacificSource PASS Chapter Logo

copyright ©2017, Portland SQL Server User Group and pdxssug.com all rights reserved.
Redistribution of any portion of this site is forbidden without prior written permission.