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
(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
(This post was updated on 5 February 2022.) Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL… Read More »Fix SQL Server with one click
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
Earlier this year I released a free T-SQL script that will calculate the correct amount of RAM you should allocate to SQL Server, assuming it is a… Read More »Updated Max Server Memory Script
Some time ago, I added a free resource to this site to help DBAs know how much max server memory should be assigned to SQL… Read More »Max Server Memory Revisited
When we perform diagnostics on an existing SQL Server instance, or if we are setting up a new machine, it’s very important to make sure… Read More »Max Server Memory Matrix