June 21, 2010 at 10:21 am
A server has only one local drive and very low free space. It already has informatica.
They want SQL Server 2005 on the same server for SSIS.
What could be the optimum RAID level that can be recommended.
Was thinking of recommending 3 partitions of 150 GB each
June 21, 2010 at 10:31 am
RAID has nothing to do with size. In terms of SSIS and Informatica, it's just having resources to run them both.
For protection, RAID 1, 10, 5 can work. R5 has a write performance penalty, so if you are doing lots of writing to these disks, it can be slowed than R1 or R10.
For partitions, that's based on what you need in terms of space, and separation. Performance can help, if the application can run different threads to different partitions at the same time for parallel operations. If it can't then one large partition works just as good.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply