Home > SQL Server > SQL Server 2005 Standard cannot lock pages in memory

SQL Server 2005 Standard cannot lock pages in memory

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.
Advertisements
  1. Kim
    May 14, 2007 at 11:19

    Thanks for the post- I hadn\’t noticed the version dependence before 😦 Shame for me, since most of our customers are running Standard edition…
     
    /Kim

  1. April 20, 2011 at 12:34

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s