Some of you might know me because of the Max Server Memory Matrix, a chart I created based off a decade-old algorithm developed by Jonathan… Read More »Max server memory recommendations are just a suggestion
Max Server Memory
(Thanks to Erik Darling for reviewing this post. Check out his training materials.) One of the bigger clichés in the data professional vocabulary (behind “it… Read More »How does the buffer pool handle low memory conditions?
In 2016 I created the Max Server Memory Matrix as a guide for configuring the maximum amount of memory that should be assigned to SQL Server,… Read More »Better SQL Server memory defaults in 2019
(This post was updated on 1 August 2022.) A few months ago I suggested that the following settings should be the default for most SQL… Read More »Proposed SQL Server defaults: max server memory
Last week, I posted this statement on Twitter, along with a screen capture of the official Microsoft documentation: Reminder: Max Server Memory is *not* just… Read More »What you need to know about memory limits on SQL Server
(This post was last updated on 1 August 2022.) Everything changed for SQL Server Standard Edition on 16 November 2016, and how memory limits work.… Read More »Max Server Memory and SQL Server 2016 Service Pack 1