CSS SQL Server Engineers

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services

Clarification about the two LPIM upgrade rules that did not FAIL

Clarification about the two LPIM upgrade rules that did not FAIL

  • Comments 1

Consider the following scenario on a X64 system:
     You install SQL Server [2008 R2, 2008, 2005] standard edition.
     You grant the "Lock Pages in Memory" user right to the SQL Server service startup account.
     You did not enable the trace flag 845, as a result the SQL Server instance did not use locked page allocations
     Now you attempt to upgrade this SQL Server instance to SQL Server 2012.
     Now the upgraded SQL Server instance starts using locked page allocations.
     There is a upgrade rule named "LPIM check for x64 installations" which is supposed to warn you about this change in behavior. But you notice that this rule indicates PASSED for the above circumstances.

Consider the following scenario on a X86 system:
     You install SQL Server [2008 R2, 2008, 2005] standard edition.
     You grant the "Lock Pages in Memory" user right to the SQL Server service startup account.
     You did not setup and configure the ‘awe enabled’ feature, as a result the SQL Server instance did not use locked pages allocations
     Now you attempt to upgrade this SQL Server instance to SQL Server 2012.
     Now the upgraded SQL Server instance starts using locked page allocations.
     There is a upgrade rule named "LPIM check for x86 installations" which is supposed to warn you about this change in behavior. But you notice that this rule indicates PASSED for the above circumstances.

The upgrade rule shows a PASSED status due to a bug in the upgrade rule code. The upgrade rule incorrectly checks for the "Lock Pages in Memory" user right assignment.

A bug is filed and work is underway to fix this in a future Cumulative Update.

You can find more information about the change in behavior from the Knowledge Base article:
     2659143    How to enable the "locked pages" feature in SQL Server 2012
      http://support.microsoft.com/default.aspx?scid=kb;EN-US;2659143

Aaron Bertrand originally blogged about these two rules not working in the blog: http://sqlblog.com/blogs/aaron_bertrand/archive/2012/02/06/upgrading-to-sql-server-2012-with-lock-pages-in-memory.aspx

Thanks
Suresh Kandoth
Microsoft

Leave a Comment
  • Please add 7 and 7 and type the answer here:
  • Post
  • This issue is not addressed in the following update:

    2708594 FIX: Locked page allocations are enabled without any warning after you upgrade to SQL Server 2012

    support.microsoft.com/.../EN-US

Page 1 of 1 (1 items)