SQL Server Max Memory Settings

John Couch 181 Reputation points
2022-04-11T19:05:54.053+00:00

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.

192005-image.png

https://support.microsoft.com/en-us/topic/memory-configuration-and-sizing-considerations-in-sql-server-2012-and-later-versions-b79d7e66-78e2-9866-c0ef-0cf6991cec3d

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

Accepted answer
  1. Seeya Xi-MSFT 16,426 Reputation points
    2022-04-12T06:49:27.84+00:00

    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,
    Seeya


    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 181 Reputation points
    2022-04-11T19:37:18.81+00:00

    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