April 28, 2009 at 11:30 am
I am trying to get SQL Server 2005 to use more than the 1.7 GB of memory it seems to be capped at. I've looked through the forums and Google'd this to death. I can't seem to find out how to fix this. I've searched for a boot.ini file on my system to try and switch the /3GB setting, but there is no 'boot.ini' file anywhere on the server. Any help would be GREATLY appreciated. Thanks!
I am running the following:
1. Windows Server 2003 Standard - 64 Bit
2. SQL Server 2005 Standard - 64 Bit
3. 4 GB Physical Memory
4. Dual Opteron 285 CPUs
SQL Server is configured with the following values:
1. AWE is ENABLED
2. Max Memory (in MB): 3584 (3.5 GB)
April 28, 2009 at 11:40 am
AWE should not be enabled on a 64bit system as the OS can handle the memory natively, additionally there is no need for the /3GB switch.
Check the max memory value that you are using, and confirm that SQL is using all that it has, if not it won't request more.
April 28, 2009 at 12:05 pm
How do I
confirm that SQL is using all that it has
?
Are there queries I can run or should I just look in the task manager/processes?
April 28, 2009 at 3:35 pm
1) Disable AWE first.
2) Run DBCC MEMORYSTATUS to check the actual memory used by SQL Server. Your SQL Server may lightly memory hit.
3) If you want SQL Server to get and keep more memory, you can set Min Server Memory to 2.5 GB and restart SQL Server service, SQL will reqeust 2.5 GB at the startup and never release back to system.
4) 3.5 GB Max Server Memory sounds too big for 4GB RAM, consider to use 3GB and increase size of virtual memory.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply