THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Trace Flags » lock pages in memory   (RSS)
  • Upgrading to SQL Server 2012 with Lock Pages in Memory

    During SQL Server 2012 RC0 setup (specifically when upgrading), you may have noticed upgrade rules regarding Lock Pages in Memory (LPIM): However, for most folks, these rules always pass, whether or not they are actually using LPIM. I wanted to run a few tests to demonstrate why this is - or at least in which situations the rule checks will ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 6, 2012
  • SQL Server 2008 R2 still requires a trace flag for Lock Pages in Memory

    Almost two years ago, I blogged that Lock Pages in Memory was finally available to Standard Edition customers (Enterprise Edition customers had long been deemed smart enough to not abuse this feature).  In addition to applying a cumulative update (2005 SP3 CU4 or 2008 SP1 CU2), in order to take advantage of LPIM, you also had to enable trace ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 7, 2011
  • Big News : Lock Pages in Memory for Standard Edition

    After much feedback from customers (and some loud feedback from MVPs, led primarily by Maciej Pilecki), Microsoft's Bob Ward just announced at the European PASS Conference that they are going to allow the 'lock pages in memory' privilege for all the lowly peons running Standard Edition.  Currently this has only been allowed on Enterprise ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 24, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement