Navigation

Search

Site Content

Syndicate

Home | SQL Server 2005 DBA

Microsoft to add Lock Pages in Memory to Standard Edition

Tue, 05/26/2009 - 13:26 |  sqlguychuck
No votes yet

Bob Ward wrote up an article on the subject. Basically, you add trace flag 845 as a startup parameter. You will need SP1 Cumulative Update (CU) 2 (SP1) for SQL 2008 and CU4 (SP3) SQL 2005.
CSSSQL team blog wrote up a good article now that it is released.

Share this  |  Login or register to post comments |  Tags: SQL 2005 DBA, SQL 2008 DBA

Contact Us | Terms of Use | Trademarks | Privacy Statement
Copyright © 2010 SQLWebpedia. All Rights Reserved.

Creative Commons License
This work by Chuck Lathrope is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.

Disclaimer for all content: No warranty is expressed or implied by the authors' or owner's of this website or content linked externally. Use at your own risk.