Post reply

Lock Pages in Memory settings

  • April 26, 2013 at 11:24 am

    #394679

    Hi All,

    As per below link article:-

    http://support.microsoft.com/kb/970070

    Support for Locked Pages on SQL Server 2005 Standard Edition 64-bit systems was made available from

    "Cumulative update package 4 for SQL Server 2005 Service Pack 3"

    onwards.

    Can anyone please let me know about the:-

    1. Is Lock pages in memory availability on SQL Server 2005 Standard Edition 32-bit systems ?

    2. On which version (SP + CU) on 32 bit systems for SS 2005 Standard Edn 32 bit, support for locak pages in memory is available?

    Thanks in advance,

    Regards,

    Ankur

  • April 26, 2013 at 12:09 pm

    #1610480

    ankur_libra (4/26/2013)

    Hi All,

    As per below link article:-

    http://support.microsoft.com/kb/970070

    Support for Locked Pages on SQL Server 2005 Standard Edition 64-bit systems was made available from

    "Cumulative update package 4 for SQL Server 2005 Service Pack 3"

    onwards.

    Can anyone please let me know about the:-

    1. Is Lock pages in memory availability on SQL Server 2005 Standard Edition 32-bit systems ?

    Yes, by enabling AWE.

    2. On which version (SP + CU) on 32 bit systems for SS 2005 Standard Edn 32 bit, support for locak pages in memory is available?

    Since RTM as far as I know. Only the 64-bit editions had the shortfall since they do not respect the AWE flag, hence the addition of support via a Trace Flag in a later CU.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • April 26, 2013 at 12:12 pm

    #1610482

    Hi,

    Thanks for the confirmation

    This is what I am looking for.

    🙂

    Regards,

    Ankur

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

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