On 18/02, Michael Green wrote: > You are given 4 spindles to place TSM DB on them. > How would you set them up to squeeze maximum performance for DB? > > 1. Dedicate each spindle for a DBC (result: 3 DBCs, one spindle left > out, nevermind) > 2. Create RAID 0 out of each pair of disks. Place a DBC on each RAID > (result: 2 DBCs on two separate RAID 0) > 3. Create RAID 1 out of each pair of disks. Place a DBC on each RAID > (result: 2 DBCs on two separate RAID 1) > 4. Create RAID 5 out of all spindles. Place one DBC on the RAID > (result: 1 DBC on RAID5) > > Notes: > a. There is no RAID 0+1 > c. Wasted space is not a concern > -- > Warm regards, > Michael Green
4. RAID5 will give you the maximum amount of IOPS for the DB with disk redundancy, though 4 disks is on the low side. TSM mirroring doesnt help performance when doing expiration or reclamation anyway which is what you want to optimize the DB for. -km
