SQL Server, Locked Pages, and Standard SKU…

I made an announcement today while speaking at Europe PASS 2009 that we will be providing a method for customers using standard SKU for SQL Server 2005 and 2008 to use the ‘Locked Pages in Memory’ privilege to allow the server to use the AWE APIs. This is often referred to as “locked pages” for SQL Server to assist with working set trim problems.

I won’t provide all the details at this time to understand how to use this but I wanted to post this as soon as possible and let you know that the product team has heard your feedback.

This will come in the form of a trace flag that can be enabled on the following upcoming cumulative updates:

CU2 for SQL Server 2008 SP1 – Currently scheduled for May 2009

CU4 for SQL Server 2005 SP3 – Currently scheduled for June 2009

When we ship these cumulative updates we will be providing an article that describes how to use the trace flag along with guidelines for its usage.


Bob Ward

Comments (12)
  1. After much feedback from customers (and some loud feedback from MVPs, led primarily by Maciej Pilecki

  2. This came up at the SQLSaturday speaker dinner tonight and I had missed Bob Ward’s post about it. 

  3. Bob Ward sprach auf der European Pass Conference 2009: ‘lock pages in memory’ privilege wird es für die Standard Editionen SQL Server 2005 und 2008 geben… …

  4. Amit's blog says:

        Have you faced any SQL Server working set trimming problems (Don’t know this? Read Here

  5. Until now "Lock Pages In Memory" was an option only available to SQL Server Enterprise Edition customers.

  6. JungSun says:

    Thank you for your greate decision ^^

  7. SQL Server says:

    Microsoft ha anunciado que la versión estándar de SQL Server va a soportar Locked Pages http://blogs

  8. The W Blog says:

    SQL 2005/2008 Standard To Get Lock Pages in Memory Privilege

  9. I posted in April that we would be releasing cumulative updates for SQL Server 2008 and 2005 to support

  10. Ray says:


    What is the latest CU for SQL 2005 SP3 (build#)?



  11. laxman says:

    i got this error in ssas

    pls guide me

    Errors related to feature availability and configuration: The 'Measure expressions' feature is not included in the 'Standard Edition' SKU. 0 0

Comments are closed.

Skip to main content