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.]
Check It Out!
