Post reply

min and max memory settings in SQL 2008

  • November 5, 2008 at 10:59 am

    #383312

    We're running SQL 2008 DE on a test server with 16 GB of ram. The OS is Win2003 Server EE, 32 bit. AWE is enabled. Nothing else is running on the machine. What is the best configuration for min and max memory setting? Right now min is set to 0 and max is set to 13000.

  • November 5, 2008 at 12:00 pm

    #894463

    That's a good config you have there. You could probably bump the max to 14 if there's nothing running on the server.

    I seldom bother setting the min in SQL 2005 and higher. The minimum isn't the amount that SQL will take as it starts up, just the value that it will not drop below once it has been reached. If there's nothing else on the server, there's no reason SQL would be forced to reduce memory usage.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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