Hello!

I am just trying to confirm that 'lock pages in memory' has no effect on SQL
Server 2008 64-bit Standard Edition unless I have SP1 CU2 installed:

http://support.microsoft.com/kb/918483

I have just setup Active/Active SQL Server 2008 64-bit STD SP1 cluster. I
was wondering if ability to grant 'lock pages in memory' is a good enough
reason to install CU2.


Advice on this matter is greatly appreciated,
Igor

Opinions seem to be mixed on this one - but I would favour configuring SQL
Server memory usage such that it is highly unlikely that it'll be affected
by paging operations making "Lock Pages in Memory" redundant.

http://blogs.technet.com/askperf/arc...y-need-it.aspx

....is a good article - although it doesn't really answer the question!

"Igor Marchenko" <IgorMarchenko (AT) discussions (DOT) microsoft.com> wrote



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4671 (20091208) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Will Alber (junk (AT) crazy-pug (DOT) co.uk) writes:
Hm, you can't. The point with Lock Pages is that if a driver or some
other component goes mad and starts to chew memory, it will not lead to
SQL Server to be swapped out.

The only argument against it, as I see it, is that a CU is not as well
tested as a Service Pack, and you are taking a bit of a risk there.
Then again, if you ever see SQL Server being swapped out, you should get
this CU, because then you are experiencing a problem addressed by the
hotfix (as it says in the boilerplate.)

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Very true - although all the software on my servers is perfect and would
never run away with memory (ahem!) :-D

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4674 (20091209) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com