pooyan_pdm (8/22/2012)
Raid 10 is a better option if you have enough disk space.The write are done faster on raid 10 beacause unlike raid 5 there's no need to calculate the parity.So the overall system performance would be degraded if you choose Raid 5 for tempdb.
This now depends on your equipment and software as much as anything else. RAID 5 has been better optimized, and current speed tests (particularly on big iron with huge caches) show negligible differences under the majority of circumstances. RAID 10 is still SAFER, as you can handle a double drive loss as long as it's not the same stripe, but the speed difference has significantly dwindled. The older your equipment/software, the more likely pooyan's point will be true, however.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA