November 17, 2008 at 8:54 pm
Hello,
I'm confused as to why my SQL server enterprise edition isn't taking the setting that I have set for AWE. I did the /3gb & /PAE in the boot.ini and enable "AWE" and set the max mem. to 5144 MB but once I reboot and perform a dbcc memorystatus I see is AWE allocated as 983040 KB, why isn't the setting kicking in? I have 2003 Enterprise Windows 32 bit running 2005 SQl enterprise with 8 GB of ram. I'm trying to figure out why in task manager I"m getting available memory of 7 GB when I've set this setting for 5144 MB. Eventually, I see the RAM decreasing to about 4 GB and the page file increase about 3 GB. What is causing this? Can someone point me to the right direction as to what couters to run to narrow down the culprit that is causing the paging and why the AWE setting isn't taking. Thank!
November 18, 2008 at 4:43 am
I guess you need to execute
RECONFIGURE [ WITH OVERRIDE ]
to take the effect and restart.
Also /3gb swithch itself notifies that initial pagefile size for sql database is 3 GB.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply