June 20, 2011 at 12:01 pm
Here is an issue I'm trying to find an explanation for. Thanks upfront guys.
OS - 32bit Windows 2003R2
Physical Mem - 64 GB
SQL Server - 2005 SP2
AWE Enabled
Error in SQL Log -
"A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 42970516, committed (KB): 475788, memory utilization: 4%."
I noticed that my Buffer Cache Hit Ratio stays about 100% all the time, but my Page Life Expectance kept dropping. It would keep going higher and as it reaces may be 20 min, it just drops and then repeats.
I modified the boot.ini to remove the \PAE switch and all went well. My assumption was adding a PAE switch would only make it better for all the processes running on the server as it can expand the memory range.
Shinoj
June 21, 2011 at 6:14 am
OS - 32bit Windows 2003R2
standard or enterprise
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 21, 2011 at 6:50 am
Shinoj Ramanathan (6/20/2011)
Here is an issue I'm trying to find an explanation for. Thanks upfront guys.OS - 32bit Windows 2003R2
Physical Mem - 64 GB
SQL Server - 2005 SP2
AWE Enabled
Error in SQL Log -
"A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 42970516, committed (KB): 475788, memory utilization: 4%."
I noticed that my Buffer Cache Hit Ratio stays about 100% all the time, but my Page Life Expectance kept dropping. It would keep going higher and as it reaces may be 20 min, it just drops and then repeats.
I modified the boot.ini to remove the \PAE switch and all went well. My assumption was adding a PAE switch would only make it better for all the processes running on the server as it can expand the memory range.
Shinoj
Windows 2003 automatically enables PAE via DEP, unless you actually specified /NOPAE in the boot.ini it will still be active. Can you post full command line details of the boot.ini
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply