Lock Pages in Memory settings

• ankur_libra

  Hall of Fame

  Points: 3999

  More actions

  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

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  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

• ankur_libra

  Hall of Fame

  Points: 3999

  More actions

  April 26, 2013 at 12:12 pm

  #1610482

  Hi,

  Thanks for the confirmation

  This is what I am looking for.

  

  Regards,

  Ankur