When a SQL Server is configured correctly, it doesn’t use the page file for memory. In theory, we don’t need a page file at

all. Properly configure the Page File settings

a. Ensure the sum of all page files is equal to the amount of memory in server.

b. Do not let the system manager your page file.

c. Ensure the Initial Size and Maximum Size have the same settings.

1、分割存于多个硬盘

2、硬盘需有足够空间

3、最小值等于最大值

http://blog.sina.com.cn/s/blog_4b47ed250100edpd.html

http://baike.baidu.com/view/724336.htm