Post reply

Is it preferred to keep the SQL server Min memory to the 0 (default)?

  • August 15, 2021 at 3:32 pm

    #3920106

    Hello,

     

    Is it prefer https://breakfasthoursofficial.com/chick-fil-a-lunch-hour

    https://breakfasthoursofficial.com/carls-jr-breakfast-hours

    https://breakfasthoursofficial.com/subway-breakfast-hours red to keep the SQL server Min memory to the 0 (default)?

    Seeking expert opinion to know what is the preferred option / value for SQL Server Min Memory?

    thanks

    yuvsaha

    • This topic was modified 4 years ago by yuvsaha123.

  • August 15, 2021 at 4:03 pm

    #3920133

    I never change min memory - only set max memory.  On a dedicated host for a single instance - SQL Server will grab all memory up to the max memory and won't release it, therefore min memory has no impact.  On a multi-instance host it gets a bit tricky - because it also depends on LPIM setting.  If LPIM is enabled then min memory has no bearing on each instance - because each instance locks the pages in memory.  If LPIM is not enabled on all instances, then min memory comes into play and limits how much memory SQL Server will return to the OS when requested.

    In a multi-instance host I don't want each instances memory to be subject to releasing back to the OS - so I have LPIM enabled and make sure each instance is assigned a max memory.  The total max memory for all instances will not exceed the hosts available memory and therefore won't need to be adjusted.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply