SQL Server Max Memory Settings

John Couch 176 Reputation points

Back in the day, the best practice used to be something like:

  • 1GB for every 4GB up to 16GB, then 1 GB for every 8 GB over that. i.e. 32GB would be 6 GB reserved for OS.
  • 1GB or so for 3rd party applications (monitoring, virus..etc).
  • 2GB for MultiPage Allocations
  • Worker Threads was <= 8 Cores : 1GB, <=16 Cores: 1.5GB...etc.

So, my question is, based on the memory management changes, Multipage allocations being part of the any size allocations, do MPAs still matter for being OS reserved, or should it be left as part of SQL Server memory now. I would assume the latter.



SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,880 questions
0 comments No comments
{count} votes

Accepted answer
  1. Seeya Xi-MSFT 16,261 Reputation points

    Hi @John Couch ,

    Welcome to Microsoft Q&A!
    Here is the related article which you can read: https://www.sqlshack.com/min-and-max-memory-configurations-in-sql-server-database-instances/
    Hope this could give you some help.

    Best regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 additional answer

Sort by: Most helpful
  1. John Couch 176 Reputation points

    Just because I know someone will point out this image is from 2012/2014, yes, I know, but the same memory change exists in the current versions. I just hadn't revisited it until now.

    0 comments No comments