Post reply

The /PAE dilemma

  • June 8, 2009 at 2:50 pm

    #384735

    The same Question was posted by me on technet.ms.com, but i was not satisfied... so here it is again:

    A Quick Re-Cap of our SQL Server 2005 Environment. We are at:

    Windows 2003 Standard Editions – at Service Pack 2

    SQL Server 2005 Standard Editions – at Service Pack 3

    We have 8GB of Physical RAM installed on a Physical StandAlone Server and also the Processor architecture is 2 socket (4 core each) Processors.

    My Question is: Can the the /PAE Switch be enabled in the Windows Server 2003 SP2 Standard Edition's Boot.ini (I was not able to see this in the boot.ini File)? to use all the available 8GB of RAM. (And IF the server has the capability to HOT Add Memory, the /PAE is of course not required to be in boot.ini.)

    Can you correct my statements or respond with additional info.

    Can we use this all available Memory without upgrading to Windows 2003 Enterprise Edition

    Pl can you answer this Question at the earliest and at your convenience.

    Reason:

    The /PAE can help us gain access to more than 4 GB of Physical memory as it is Supported on Standard Editions of SQL Server 2003, which in turn can help the applications like SQL Server GAIN access to more address Space as SQL Server Standard Edition is allowed to use the memory available by the OS.

    Refrences:

    http://www.microsoft.com/whdc/system/platform/server/PAE/pae_os.mspx

    http://msdn.microsoft.com/en-us/library/ms175581.aspx

    http://blogs.msdn.com/psssql/archive/2009/04/24/sql-server-locked-pages-and-standard-sku.aspx

    Maybe i have misunderstood the /PAE or i need to understand it further...

    Pl correct me if i am wrong.

    Thanks in Advance.

    Maninder
    www.dbanation.com

  • June 9, 2009 at 7:16 am

    #1006663

    I Guess the answer is http://msdn.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2003

    so assuming the /PAE is set the max memory with the switch is 4GB, so it settles the doubt...

    I guess i should start reading between the lines and slowely..

    Thanks everybody who spent time looked at this post...

    Maninder
    www.dbanation.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply