CODEWITHSUNDEEP
sql-server
SQL Learner
SQL Learner

Reputation: 601

SQL Server Lock Pages in Memory

Does SQL Server 2012 x64 standard edition running on Windows 2008 R2 has LPIM (Lock pages in memory turn on by default -- out of the box)? If not does this should be needed to be turn on?

Upvotes: 1

Views: 1431

Answers (1)

Andomar
Andomar

Reputation: 238116

Normally SQL Server is not allowed to lock pages. You have to grant rights "lock pages in memory" using the policy editor "gpedit.msc".

If it has the rights, SQL Server 2012 will use it:

The SQL Server Lock Pages in Memory option is set to ON in 32-bit and 64-bit instances of SQL Server 2012 Standard edition and higher when the account with privileges to run sqlservr.exe has been granted the Windows "Locked Pages in Memory” (LPIM) user right

Upvotes: 3

Related Questions