October 11, 2004 at 11:51 am
Memory- someone please confirm this is correct...
We have 4.5 GB of RAM in our server.
1. I have set the /3GB and /PAE switches in the boot.ini file. (requires reboot)
2. Too enable awe.... (requires service restart)
step 1:
SP_CONFIGURE 'show advanced options', 1
RECONFIGURE
GO
SP_CONFIGURE 'awe enabled', 1
RECONFIGURE
GO
step 2:
SQL service is running undera domain account with this profile setting: “Lock pages in memory”
step 3: AWE requires me to set a fixed memory setting in the SQL Server properties.
IF I was not using awe, I could leave it to Dynamci and it would make use of 3GB of RAM, right???....and given the right load I would see that in task manager, right?
October 11, 2004 at 5:37 pm
October 11, 2004 at 7:48 pm
And setting it to 4GB out of the 4.5 GB available is a good idea?
October 11, 2004 at 10:57 pm
I can find the settings for the /3Gb switch, but I cannot find how to use it when using multiple instances on a machine. 2 node cluster, active/active (2 instances each node), 4 instances, 16Gb memory.
Anyone?
October 14, 2004 at 1:54 am
I've used almost the same exact setup on a servers with 2 instances with 4 GB on W2K. MSSQL divides or reserves the memory even if one of the instances isn't used. If you have 16 GB of memory you will not be ale to use the /3GB memory as the full 2 GB of OS memory is needed to manage the additional memory.
However on W2K3 that's not much of an issue as it natively address up to 32 GB. I have a machine like that with one instance that's uses almost the full 16 GB for MSSQL and we're using dynamic addressing and not setting the min / max server memory as required with AWE on W2K with 8 GB of memory on W2K Advanced server.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply