May 31, 2003 at 2:29 pm
I am using SQL serve enterprise edition with Win2K advanced server on a machine with 6GB RAM. I want to allocate SQL server the max memory it can have on this server. For this reason I am using AWE to address memory more than 3GB. AWE gets enabled (as I can see in the log file), but following error message is also coming.
"initdata: Warning: Could not set the working set size to 3651416 KB".
If I see in the Performance Counter: SQL Server: Memory Manager: Total Server Memory, I can see that the required memory (which i set in the "max server memory" which is approx. 3.5GB) has been allocated to the server. Then why I am getting this error message. SQL server on my machine is running as a service.
Following are the details of my system.
-Win2K Advanced Server SP3
-SQL Server 2000 Ent. edition SP2
-6GB RAM (also detected by the OS)
-2 Xeon processor machine
- /3GB and /PAE switches are set in boot.ini file
SQL server configuration:
- awe enabled=1
- set working set size=1
- min server memory=3.5GB
- max server memory=3.5GB
June 3, 2003 at 9:35 am
June 4, 2003 at 1:35 am
yes the /3GB switch is set as I already mentioned in the problem text.
The information that I have got so far is that we should not use AWE and "set working set size" togather as they both can conflict each other. AWE is reserving the memory for itself via OS, whereas "set working set size" is also doing the same "reserving the memory for SQL server". So far this logic seems to be valid to me. If any body has any other idea, please let me know.
June 4, 2003 at 9:28 am
Someone else needs to verify, but as far as I remember, if you use PAE, you do not use AWE.
sorry, i missed the 3gb in your first post.
Steve Jones
June 4, 2003 at 9:42 am
To enable Windows 2000 Advanced Server or Windows 2000 Datacenter Server to support more than 4 GB of physical memory, you must add the /pae parameter to the boot.ini file.
Microsoft® SQL Server™ 2000 Enterprise Edition uses the Microsoft Windows® 2000 Address Windowing Extensions (AWE) API to support very large amounts of physical memory. When awe enabled is set to 1, AWE memory is used, and the instance can access up to 8 GB of physical memory on Windows 2000 Advanced Server and 64 GB on Windows 2000 Data Center.
June 9, 2003 at 5:56 am
The final configuration that I so far could agreed on and looks logical to me is....
- use /3GB and /PAE switches in the boot.ini file
- enable AWE with certain max server memory.
- do not enable "set working set size" option in the sql configuration.
Thanks and regards for your contribution.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply