I am setting up a new Win Server 2008 R2 server to be a SQL 2008 R2 server. I have 32GB RAM and 2 RAID arrays: 2x73GB RAID 1 and 3x146GB RAID 5.
How big of a page file should I plan for? If possible I had wanted to divide the first array into a C drive for the OS and paging file and an E drive for the log files. I need at least 20 GB for the logs. The SQL DB itself is 37GB.
In previous Operating Systems, the default paging file size was determined differently on different versions of Windows. In general, the recommended page
file size is 1.5 times the amount of RAM installed on your computer.
However, in Windows 7 and Server 2008 R2 the default size is equal to or a litter bigger than the amount of memory installed in the machine. In your scenario,
to configure the page file size on SQL server, I would like to recommend you to visit the following article:
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”
Marked as answer byJason MertzWednesday, November 17, 2010 3:42 PM
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.