MS announces support for ‘lock pages in memory’ for Standard Edition

Finally! All those customers out there who are frustrated by not being able to turn on the 'lock pages in memory' option to protect the SQL working set on Standard Edition – the wait is nearly over. Bob Ward (Principal Escalation Engineer in CSS, and a good friend of mine) announced at PASS Europe that the option is soon to be supported – in the May CU for SQL 2008 and the June CU for SQL 2005. You can read a little more in his blog entry here.

If you don't know what this is, checkout this entry in Books Online – it basically prevents Windows paging out SQL memory to disk.

[Edit: the bits containing this fix have been released for 2008. See here for details.]

Posted Under:

Bugfixes, Memory, Performance Tuning

Leave a Reply Cancel reply

Other articles

Reflections on 15 Years

(This was the editorial for my 300th SQLskills Insider newsletter last week, that I’ve been producing since March 2011! See bottom of browser window to

Presenting a workshop at PASS Summit West in Seattle!

I’m excited to be presenting at the Pass Summit in November! My pre-con workshop is my absolute favorite to teach Performance Tuning with Waits and

Summer Sale: $699 Blackbelt Bundle!

Summer Sale time! Hundreds of dollars lower-than-ever prices on our signature 158-hour Blackbelt training bundle: Check It Out! SQL Server Jumpstart+ Bundle $4,070.00 Original price

The SQL Server Transaction Log, Part 4: Log Records

(This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website was mothballed later in 2022 and the

SQL101: Application data consistency checking

It’s quite common for a company that experiences a corruption-causing disaster, but has no valid backups to restore from and no ability to fail over

SQL101: Phishing attacks

I thought it was bad previously, but in 2026 I’ve noticed a big rise in emails trying to scam me into clicking a link –

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.