Which raid for tempdb

In weighing the decision, you should consider the number of write and read options. RAID 10, for example, would be a good option for those databases with more write operations. Other factors include the other files being stored, including database transaction log files and backup and recovery files. You will also need to consider the possibility more storage might be needed to implement a new storage or backup strategy and the potential costs associated with it.

More generally, Microsoft TechNet suggests :. Data striping RAID 0 is the RAID configuration with the highest performance, but if one disk fails, all the data on the stripe set becomes inaccessible. A common installation technique for relational database management systems is to configure the database on a RAID 0 drive and then place the transaction log on a mirrored drive RAID 1. For any data that has to be rapidly recoverable, RAID 5 is the better option.

This level of RAID gives users full redundancy of all the data on the array. This is useful if a single disk happens to fail. The disk can be easily replaced, most often, without any system downtime. If you need help with performance tuning or reconfiguring your SQL Server storage , please feel free to contact Datavail to discuss a custom solution designed for your enterprise.

You can learn more about our remote database services and how our experts can help with your ongoing SharePoint operations. Eric Russo. Shortcut to Fixing a Corrupted Oracle Inventory. Oracle Central Inventory files are essential to installing and patching software.

You need a minimum of two disks to form a RAID 1 array. This RAID level offers better read performance but slower write performance. The main disadvantage is out of 2 disks only 1 disk used to store the data.

SQL Server writes data to the transaction logs and maintains serial information of all modifications that occurred in a SQL database. The transaction log files can be used for rollback and roll forward of information from a SQL Server database. You should first mirror disks and then create a stripe set of mirrored disks. This provides high fault tolerance for data and excellent throughput performance.

It all depends on your system and usage etc. I tend to agree with the Raid 1, Raid 10, Raid 1 setup. I am actually using this setup and it performs much better than the original 5 disk Raid 5 the original dba had configured. I will caution however that though it seems statistically unlikely, I've personally had 3 disks fail in that Raid 10 at the same time.

Actually, the statistical likelihood of multiple disk failures in RAID arrays has been widely understated. The mathematical models that failure rates were based on did not accurately reflect the reality of what happens during RAID rebuild.

Multiple disk failures are actually fairly common and RAID 5 is especially vulnerable. Seems like a valid setup, though if you can carve off the space I would put the backups on a different drive to the databases!

You must be logged in to reply to this topic. Login to reply. August 21, at pm This is DAS disks. I now came into a question. As this box is only used for database, we want to have partitions for OS, data file, log file and temp db.

Now I there is a dilemma: I know for best practise, temp db should on its own physical disk. If I set up four partition logical drives , one for OS, one for data files, one for logs and one for temp db, then I can only have RAID 1 on each of the disk array. But the advantage of this is temp db is only its own disk. Or the second choice I can have is to partition the disks into three array logical drives , namely OS, data files and logs. Could you give me some idea, which one is better?

Any disscussions are welcome. Thank you very much. August 23, at pm No straight answers, but a few ideas. Cheers Leo Leo Nothing in life is ever so complicated that with a little work it can't be made more complicated.