Post reply

Confused-Lock Pages In Memory-Yes/No

  • January 18, 2011 at 10:58 am

    #243818

    Hi Folks

    i could have sworn that when I installed SQL Server2005 (Windows 2003-64bit) and SQL Server 2008 (Windows 2008-64bit), for that matter, that i had notes that said to 'Lock Pages In Memory" even on 64-bit OS.

    Can someone tell me if I am right on this issue or not because these articles say NOT to 'Lock Pages In Memory" on 64-bit os

    http://msdn.microsoft.com/en-us/library/ms190730.aspx

    http://msdn.microsoft.com/en-us/library/ms190730(v=SQL.90).aspx

    In addition I have "Use AWE to allocate memory" checked

    Thanks

    Jim

  • January 18, 2011 at 3:18 pm

    #1275011

    I think those documents are a bit mis-leading and confusing. You have to take the into account the context of the document.

    Both documents are referring to enabling this feature for AWE support. Which is only required on 32-bit OS's. Both documents also do not state NOT to enable it on x64, rather - they state it is not required.

    Again, in the context of the document - enabling locked pages is memory is not required to use AWE in x64 because it is not needed for that purpose.

    On x64 boxes, I enable this option for any system that has more than 4GB of memory available and the system is dedicated to SQL Server. If I am also running SSIS/SSRS/SSAS on the system I would use lock pages in memory to prevent those other applications from taking that memory away from SQL Server.

    Also, don't forget to set a reasonable max memory. If you don't do this, you could find SQL Server taking all available memory on the system. And if you set this policy it would be even worse because the OS couldn't page out any memory when needed.

    The AWE setting is not needed on x64 systems and does not have any effect whether checked or not.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • January 25, 2011 at 8:48 am

    #1277920

    Hi Jeffrey

    thanks very much for your insight regarding this one

    Jim

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply