Re: RAID5 question, take 2

2001-06-10 Thread Jared Still
On Sunday 10 June 2001 20:15, Gary Weber wrote: > The question is, and I promise this is the very last time I post it: given > 9 hard drives dedicated for RAID5, should data reside on 6 drives via > volume group A and indexes on the other 3 drives via volume group B, or > should data and indexes

Re: RAID5 question, take 2

2001-06-10 Thread Paul Drake
Gary, Here is where we have to know more details. a 9 drive array on a single channel sounds like your peak I/O rate for reads would be throttled by the controller channel speed. Now, if the SCSI interface is ultra 160/m, and the drive support a sustained rate of 20 MB/sec - you're not pinched.

Re: RAID5 question, take 2

2001-06-10 Thread Mogens Nørgaard
Indeed, Paul. Very good points. Gary - you're asking us to determine the number of bags we'll need at the supermarket without knowing what we're going to buy. If we had IO-stats for your datafiles/tablespaces, ie reads/writes and their size, and your availability requirements on the system, we co

RE: RAID5 question, take 2

2001-06-11 Thread Gary Weber
Mogens, the super-market analogy does not apply - this is for SQL Server database. I'm not sure how far I'll be able to tweak that rdbms, hence my question did not contain many details - it was simply a request for opinions. Btw, to sum up current responses: Option 1: split 9 drives to separate d

RE: RAID5 question, take 2

2001-06-11 Thread Christopher Spence
This actually depends on the drives, if they are cheetahs, yeah you will be pinched. But if it is anything but perhaps not. I would hope they would be, but very possible they are not. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Sp