Today, I by accident discovered that SQL Server 2005 cannot lock pages in memory on the Standard Edition. The documentation for this is well hidden away. Look at the knowledge base article:

 

 

Look Under Applies to: you will only see Enterprise Edition. Today I validated this to be true, you cannot prevent SQL Server from being pages out on a Standard Edition.

 

Locking pages i memory is a recommended configuration of SQL Server. You do it by granting the SQL Server Service account the privilege "Lock Pages in Memory" (using gpedit.msc). The effect is that SQL Server will not be swapped out by the operating system - an operation that, if it occurs, can mean a very serious performance degradation.

 

You can validate that your SQL Server is running with locked pages by looking for the message: Using locked pages for buffer pool in the SQL Server log.