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?
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.