Post reply

A Question About Memory Management in SQL Server 2012

  • June 25, 2014 at 7:59 am

    #309474

    To use dynamic memory management in SQL Server 2012, do you have to leave the settings at the default values or can you specify a range?

    If you wanted to disable dynamic memory management, would you set the same value for the min and the max?

    Peter MaloofServing Data

  • June 25, 2014 at 8:27 am

    #1724656

    1) NEVER EVER leave max memory at the default. It is a somewhat religious discussion to pick a number for any given machine, but there are several reasonable guidelines to be found online.

    2) I wouldn't set min=max either. Can probably find justification for that online too.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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