Monday, March 26, 2012

Lock Pages in Memory on x64 Standard

All,

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.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.

No comments:

Post a Comment