September 10, 2019 at 6:44 pm
Hi Experts,
I have a doubt on lock pages in memory.
We have sql 2012/2016 64-bit enviroments.
Question is, do we need explicity enable lock pages for 64bit sql servers or it is not required?
As per my knowledge it is used for 32-bit systems as virtual address space is low.
Thanks,
Sam
September 11, 2019 at 3:58 pm
This has been a long running debate.... for example, see:
Personally, I don't see a danger in enabling it on x64 systems (and ensuring the MSSQL service account is granted the correct permissions). It will help ensure your MSSQL instance has the memory you want it to have. On the other hand, it is not *required* so it remains as your informed choice.
September 11, 2019 at 6:04 pm
Just be aware that if you enable it - you *must* set a max memory for SQL Server. If you do not set the max memory then SQL Server will eventually consume all memory available and starve the OS (and other processes).
If you do not set locked pages - SQL Server can still take all memory - but the OS can request that memory back and it will be granted (eventually). With locked pages - SQL Server will not release that memory back to the OS.
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply