Windows Page File Explained

The Ask the Performance Team blog from Microsoft’s Enterprise Platforms Windows Server Performance Team has a useful post called "What is the Page File for anyway?", written by CC Hameed. The post does a good job explaining how Page Files are used and how to properly configure and maintain them.

I completely agree that you should set a static Page File size rather than using a dynamic Page File Size (which is the Windows default). For big SQL Server  2005 dedicated 64-bit servers, hopefully you have enough RAM, and you have enabled "Lock Pages in Memory" for the SQL Server Service Account, so that you are not seeing much if any Page File usage (because if you are, you have other problems to worry about).

Having said that, for a 32GB, 64-bit SQL Server 2005 machine, I typically set the Page File to be a static 6GB file, usually on the C: drive.

 

Technorati Tags:
About these ads
This entry was posted in Windows Server 2008. Bookmark the permalink.

One Response to Windows Page File Explained

  1. Henry says:

    First of all ,thanks for your kindness.But could you charify your opinions clearly,you know i want to know more about how to set pagefile?

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