PAE Swith on 32bit server

  • 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

  • OS - 32bit Windows 2003R2

    standard or enterprise

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • 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