Solved

Window Page file

Posted on 2014-07-17
3
350 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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

738 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