Tuesday, March 02, 2010

VMware and SQL and Lock Pages in Memory - SQL Server with Mr. Denny

 

In other words, use Lock Pages in Memory with SQL/VMWare with great caution.

With the recent release of the ability for the Lock Pages in Memory setting to be used on SQL Server 2005 and 2008 Standard Edition I see more and more people shooting them selves in the foot with this setting when running under VMware.  I see this as becoming more of an issue now that this switch is available for Standard edition as I would assume that most virtualized SQL Server installations are done using SQL Server Standard Editions.

VMware and SQL and Lock Pages in Memory - SQL Server with Mr. Denny

1 comment:

SamH said...

Hi Wavesmash,

I couldn't find a way to contact you directly.

Nice blog, and all the way back to 2004!

I thought you might be interested in check out my SQL in Excel add-in QueryCell.

www.QueryCell.com

If you find it interesting I would love to give you some free licences to give away to your readers.

Let me know if you are interested.

Cheers
Sam Howley
www.oakfocus.net
www.QueryCell.com