GilaMonster (7/24/2013)
5+1? That's a very unusual RAID type. Don't think it would be that good for TempDB, 10 would be better, 5+1 would still have the write overhead from the parity stripe, just like plain RAID 5.
I am not quite familiar with RAID concepts! And it is Clients environment, I can't do much on that. DEV server is on 5+1 and the PROD server is on RAID 10. I faced the performance problem in DEV server only. But after did the work around, as I mentioned in this chain, no query runs more than 30 secs. Performance is really very fine.
Please suggest me some good reference to start with RAID. Thanks