Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Smile Unanswered: Lock Pages in Memory on x64 Standard


    I have a new database server running W2K3/MSSQL2K5 x64. I read in BOL that you can use the Lock Pages in Memory option to improve performance on your database server. I did some research on the internet and some sources are stating that you can only use that option with MSSQL2K5 Enterprise but in BOL they state that you can use this option in Standard/Enterprise.

    Can anyone confirm that "Lock Pages in Memory on x64 Standard" works in MSSQL2K5 Standard?

    Thanks in advance for the help.

  2. #2
    Join Date
    Mar 2007
    Holmestrand, Norway
    As far as I understand this, it is available on 32-bit systems with AWE and on 64-bit systems. The three versions supporting this feature is thus Standard, Enterprise and Developer.
    Ole Kristian Velstadbråten Bangås - Virinco - - Facebook - Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts