June 6, 2006 at 9:33 pm
We have Sql Server 2K5 (Standard) with default memory 2G running on Win Server 2K3 (Standard) with memory 4G. I would like to increase Sql server memory to 3G.
Never done this before, read a lot of info and confused: 1) probably no needs to use Awe feature; 2) probably need to use /3GB switch (i.e. edit boot.ini file from MyComputer-Properties, etc). I do not want to screw up on our production server. Thanks
June 8, 2006 at 8:00 am
Yes, AWE is not required. Just add /3GB switch in windows boot.ini. And make sure in sql memory configuration, the max mem is set to 3GB
June 8, 2006 at 9:33 am
If you need a good reference on "how-to" see these links from Microsoft:
Physical Address Extension - PAE Memory and Window
http://www.microsoft.com/whdc/system/platform/server/PAE/PAEdrv.mspx
How to configure SQL Server to use more than 2 GB of physical memory
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
June 9, 2006 at 7:48 am
Thanks, guys, for your responses. Actually I've already added this switch and checked from TaskManager-Processes that sql server consumes more than 2G (I saw 2.7G). But now I confused with another memory issue: from Sql Server-Property I see:Memory=3,455Mb and directly from Memory:maximum server memory (in Mb) =2147483647 (probably, this is 2G but not in Mb but in bytes instead). It seems I can not directly from Mangement Studio change this number to 3G. How to do this trick- use sp_configure or ...? Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply