SQL Server, Locked Pages, and Standard SKU…

  • Article

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
Microsoft

Comments

  • Anonymous
    April 23, 2009
    PingBack from http://microsoft-sharepoint.simplynetdev.com/sql-server-locked-pages-and-standard-sku%e2%80%a6/

  • Anonymous
    April 24, 2009
    After much feedback from customers (and some loud feedback from MVPs, led primarily by Maciej Pilecki

  • Anonymous
    April 24, 2009
    This came up at the SQLSaturday speaker dinner tonight and I had missed Bob Ward’s post about it. 

  • Anonymous
    April 25, 2009
    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... ...

  • Anonymous
    April 26, 2009
        Have you faced any SQL Server working set trimming problems (Don’t know this? Read Here

  • Anonymous
    April 26, 2009
    Until now "Lock Pages In Memory" was an option only available to SQL Server Enterprise Edition customers.

  • Anonymous
    April 27, 2009
    Thank you for your greate decision ^^

  • Anonymous
    April 29, 2009
    Microsoft ha anunciado que la versión estándar de SQL Server va a soportar Locked Pages http://blogs

  • Anonymous
    May 14, 2009
    SQL 2005/2008 Standard To Get Lock Pages in Memory Privilege

  • Anonymous
    May 19, 2009
    I posted in April that we would be releasing cumulative updates for SQL Server 2008 and 2005 to support

  • Anonymous
    March 26, 2010
    Hi, What is the latest CU for SQL 2005 SP3 (build#)? Regards, Ray

  • Anonymous
    April 22, 2011
    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