Home Forums SQL Server 2005 Administering new 64-bit Sql 2005 Server - integrity check completes then memory spikes 75% and doesnt lower RE: new 64-bit Sql 2005 Server - integrity check completes then memory spikes 75% and doesnt lower

  • August 20, 2009 at 11:06 am

    #1042289

    Jeffrey,

    On x64 hardware, Microsoft says that the "Lock pages in memory" right is not necessary. From this Technet article:

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

    "Locking pages in memory is not required on 64-bit operating systems."

    What makes you recommend it on x64?