Clarification about the two LPIM upgrade rules that did not FAIL
Published Jan 15 2019 02:24 PM 326 Views
Microsoft
First published on MSDN on Apr 30, 2012
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-loc...

Thanks
Suresh Kandoth
Microsoft

Version history
Last update:
‎Jan 15 2019 02:24 PM
Updated by: