Solved

Window Page file

Posted on 2014-07-17
3
332 Views
Last Modified: 2014-07-22
My Window 2008 R2 + SQL 2008R2 has the following configuration.

OS                  : 2 x 300GB  (RAID-1)
SQL TempDB : 4 x  300GB (RAID-10)
SQL  Log         : 4 x 300GB (RAID-10)
SQL Data        : 4 x 800GB (RAID-10)

Due to the limitation of the hardware, I can't configure more RAID. The server will be plugged with 192GB RAM. However, my concern is the pagefile size and program size on the OS partition.

Can the 300GB be cope with the size of SQL program + pagefile + OS ? What will be the best way to handle this in my current configuration ? Should I install SQL Program on SQL Data partition to save some space on OS partition ?

Tks
0
Comment
Question by:AXISHK
3 Comments
 
LVL 34

Accepted Solution

by:
Seth Simmons earned 250 total points
ID: 40203727
with that amount of physical memory i would have a pagefile of maybe 16gb; you really don't need a 192gb pagefile unless you need to generate a complete memory dump for support because of a stop code

with 300gb it should be fine with windows and sql install there
your raid 10 layout for sql is good
0
 

Author Comment

by:AXISHK
ID: 40203876
Should I put Window page file & SQL TempDB into same partition ? Will there be any performance issue ? Tks
0
 
LVL 8

Assisted Solution

by:barrykfl
barrykfl earned 250 total points
ID: 40203930
Window Page file u can set C/D/E ...any where accessible as you like. normal less I/O partition e.g. C: or you  make a separate just for the page file.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now