Solved

Window Page file

Posted on 2014-07-17
3
353 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 35

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

696 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