An update for Standard SKU Support for Locked Pages….

  • [アーティクル]

Note this article has been updated to include an update for SQL Server 2005

I posted in April that we would be releasing cumulative updates for SQL Server 2008 and 2005 to support the concept of Locked Pages for SQL Server Standard.

SQL Server 2008 Cumulative Update 2 for SP1 was released yesterday to provide this support. You can download the CU at:

https://support.microsoft.com/kb/970315

SQL Server 2005 Cumulative Update 4 for SP3 was also recently released to provide this support. You can download this CU at:

https://support.microsoft.com/kb/970279

We have published a KB article that talks about the change in the CU to support Locked Pages for SQL Server Standard:

Support for Locked Pages on SQL Server 2005 Standard Edition 64-bit systems and on SQL Server 2008 Standard Edition 64-bit systems

As you can read in the article, you must do the following to enable this support:

1) Install the Cumulative Update (which requires you first install SQL 2008 SP1. Remember if you have not installed SQL Server 2008 yet, you can use slipstream support to install RTM, SP1, and CU 2 all in one setup execution).

2) Enable trace flag 845 as a startup parameter

3) Ensure the service account for SQL Server has the Locked Pages in Memory privilege set. This is not required if the service account is LOCAL SYSTEM.

As part of this change, we have updated the following KB article (note the article is updated to indicate it applies to both SQL Server 2005 and 2008)  that has many more details about Locked Pages, Working Set Trim, and the possible ramifications of enabling this for 64bit systems.

How to reduce paging of buffer pool memory in the 64-bit version of SQL Server.

 

Bob Ward
Microsoft

Comments

  • Anonymous
    May 19, 2009
    PingBack from http://microsoft-sharepoint.simplynetdev.com/an-update-for-standard-sku-support-for-locked-pages%e2%80%a6/

  • Anonymous
    May 19, 2009
    Most importantly, this update includes the new trace flag that will allow users running Standard Edition

  • Anonymous
    May 24, 2009
    MS announces support for 'lock pages in memory' for Standard Edition

  • Anonymous
    September 20, 2010
    Is this update required for an environment running SQL Server 2008 SP1 Standard 32-bit using AWE and PAE?  I only see 64-bit referenced in the various posts that I've seen.  Thanks.

  • Anonymous
    September 25, 2013
    What is happening, I can't access the Microsoft Support site!!