Avatar of afflik1923
afflik1923
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Server setup - best practise for RAID on new server - opinions?

I might be old school in my thinking but I was about to supply a client a server running Windows Server 2008.
I was going to setup a C drive with Mirrored RAID (1)
And then a D drive with raid 5 where the majority of data will be kept?

The server will be running MSSQL not exchange. It will be the only server on a network of 10.

Is this still the good way to do things? Or should I just make the entire partiation RAID 5.
Will be using SCSI disks.

Windows Server 2008Server HardwareRAID

Avatar of undefined
Last Comment
afflik1923

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
vk3kjc

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Subhashish Laha

This approach will be good.
andyalder

SQL best practices would be 2 disks mirrored for OS/binaries/pagefile, 2 mirrored for transaction logs, two mirrored for TempDB and the rest in RAID 10 for data but that ends up as a lot of disks. It really depends on what you're throwing at it, if it's low write then the transaction logs can go on the disks that have the OS on and you can use RAID 5 instead of 10 for the data and have TempDB on the data disks. Or you might have high enough IOPS requirement and low enough data size to use SSDs.
vk3kjc

I would avoid having transaction logs on the OS disks. There is nothing worse than having a system that will not allow you to logon because the system disk is full. The solution by andyalder seems to be overkill for a server on a network of 10 machines.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
afflik1923

ASKER
I don't think it's going tobe that heavy hit. It will be 5 MSSQL users via Sage 200 applicaiton. Should not be too intensive.
SOLUTION
andyalder

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
vk3kjc

Point taken about two partitions in the system disks..
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
afflik1923

ASKER
I just looked up a bit more about RAID 10. Look s interesting.
http://www.thegeekstuff.com/2010/08/raid-levels-tutorial/

But bascially if I buy say 1TB of disk, that leaves me with 500GB useable right?
Or is it even less then that?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
afflik1923

ASKER
OK thanks. Sorry for the delay. That is what I meant with the disks. So actually in reality it is more likely to be
4 * 450GB SAS hard drives.

So with RAID 10 this would give me about 900GB of useable space and I would have both the C and D partiations setup only logically across these volumes.

With RAID 5 I would have more storage right as I would have something closer to 1.2GB.

So the downsize of RAID 10 is that it costs more in disk space.
kevinhsieh

Yes, if you have 4 disks you will have nominally 1 drive (450 GB) less capacity using RAID 10 vs RAID 5.
afflik1923

ASKER
All very good comments. Many thanks for the input on this.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck