RAID for database 4TB

I have a 4TB BD:

What arrangement for each type of file (DATA, LOG, TEMPDB, OS, PAGINATION, BACKUP)

Speed of each disk
Amount of Disco

I have a Windows 2008R2 database, for this change that I mentioned could go up to 2016?
enrique_aeoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
Well, without further constraints:

OS: SSD, RAID 1
PAGINATION: SSD, RAID 0 ( size depends on RAM installed)
BACKUP: SATA, RAID5 ( lots of TB )
DATA: SAS15K, RAID10 ( depending on DB growth start with 8TB+)
LOG: SAS15K, RAID10 ( depends on the loads, can range from 1TB to 20TB+ )
TEMPDB: SSD,  RAID10 ( depends on the loads and CPU, probably you need 4 RAIDS )

But you should start with an roughly guessed budget based on the business case and impact first. Then you need to take a look at the data usage. Do you need all data on the active system? Also do you plan to use a cluster?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
enrique_aeoAuthor Commented:
the TEMPDB stores temporary files, should not it be RAID 0?
0
enrique_aeoAuthor Commented:
memory = 512GB
With this information, the configurations must be modified?
0
ste5anSenior DeveloperCommented:
RAID 0 is a no go, cause when a single disk fails, the entire volume is down. And with out tempdb SQL Server cannot operate.

You need really dig into it. Cause this is defintively a large database. And the sky's the limit. Without your reqruired SLA and RPO/RTO and without having budget you can do anything.

For example, you can run such a database for sure on a single 12TB SATA array, but then you may have performance issues and DR problems.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows OS

From novice to tech pro — start learning today.