Post reply

Setting Max Server Memory in 64 bit machine

  • December 21, 2007 at 10:15 am

    #185181

    I am running SQL 2005 Standard under Windows 2003 Standard with 8 GB of RAM in one of our 64 bit servers; I noticed min server memory was set for some reason to 128 MB and max server memory to 6114 MB by the previous DBA. We plan to upgrade it to 32 GB. What is the best approach when changing those values ? Should I change those values to the defaults (0 - 2147483647) or create min and max boundaries? . This box is only utilzed by SQL.

    Also I know that those changes are reconfigured dynamically so no need to reboot, but would this place any performance hit in the server and should I use Management studio or sp_configure ? (for some reason I don't trust Management studio for these type of changes :))

    Thanks,

    Carlos

  • December 21, 2007 at 10:30 am

    #762206

    SSMS should do fine.

    If this is only a SQL server, then I would probably set Min and Max to the same value. My impression for 64bit is that you would just set the values to the value you want, so maybe 29-30GB and see what works.

    Sorry, don't have 64-bit experience with something that large.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

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

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