Large Page Extensions in SQL Server - please explain

Last Post 06 Oct 2010 01:43 PM by rm. 5 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
SQL_Jr
New Member
New Member

--
05 Oct 2010 04:05 AM

We have a 64-bit SQL Server and have assigned Lock Pages in Memory.  As soon as you add the “Lock Pages in Memory” privilege for the service account, start enabled this option.

Can someone please explain exactly what these are, when would you use them, and should they be enabled?
Should Lock Pages in Memory be enabled on 64-bit systems?

Please advise.  TIA!

rm
New Member
New Member

--
05 Oct 2010 05:23 AM
Should be enabled on all servers, that will prevent swapping cached data to page file thus better performance. In fact, that's the first thing we check here when troubleshoot performance issues.
SQL_Jr
New Member
New Member

--
05 Oct 2010 06:29 AM
Ok, thanks. My main concern was Large Page Extensions....waht is this?
rm
New Member
New Member

--
05 Oct 2010 12:25 PM
SQL_Jr
New Member
New Member

--
06 Oct 2010 04:04 AM
The resource cannot be found. Have another link? Thx
rm
New Member
New Member

--
06 Oct 2010 01:43 PM


Acceptable Use Policy
---