THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Trace Flags » x64 » 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
Privacy Statement