Hi, as others already pointed out, there are more factors to be considered. As for Raid5 vs. raid1+0, the later will almost surely improve overall performance at higher costs. Changing to either raid 1 or raid1+0 will likely etremly speed-up tasks where the database is changed, like client backups or the restoration of DB itself. As for database I would consider 2 raid1 arrays over single rad1+0 array, and a separate dbvolume per each raid1 array. This could considerably speed your database reads and writes. Allowing for 2 separate dbvolumes per each raid1 array would even further sped the reads - as there were up to 4 paralell I/0s - one per spindle. But writing would cause up to 8 parallel I/Os - 2 per spindle, which could slow things down. But - if your disk controller has a fair amount of cahce this would not matter much, and you could define even more dbvolumes. With my controller with 128MB ram and nice access optimisation 4 dbvolumes per raid1 are better than 2, but - it depends. Raid1+0 would be nice for backup storage pools, if you can afford it. .... Regards Juraj Salak -----Ursprüngliche Nachricht----- Von: Dearman, Richard [mailto:[EMAIL PROTECTED]] Gesendet am: Mittwoch, 4. April 2001 22:02 An: [EMAIL PROTECTED] Betreff: RAID5 or 0+1 I have been seeing high memory utilization and high disk busy problems on the disks that my database sits on when I do backups. I'm running AIX 4.3.3 with in a H70 with 2 cpu's and 1gb of memory. I was thinking of moving my tsm database to a RAID 0+1 setup from a RAID5 setup to see if I gain any performance. Does anyone have any suggestions on database performance issuses. Thanks ***************************EMAIL DISCLAIMER************************** This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is strictly prohibited. If you have received this e-mail in error, please delete it and notify the sender or contact Health Information Management (312) 996-3941.
