Re: Clarifying RAID questions...??

In article <19990603000238.04310.00000395@ng-fb1.aol.com>, aslialkin@aol.com (Aslialkin) wrote: > Hi All; > I would like to ask you experiments about RAID 5 and disk subsystems. > We're currently designing our new production platform regarding migration > process. > I've been reading last postings and questions about performance problems > related with RAID 5. > A current plan from sysadmin using RAID1/0 for system dbspaces. > Rootdbs,logdbs,phydbs,tempdbs. > and RAID 5 for rest of the data dbspaces. > Is there anyone experienced similar physical disk design on platform like ours. > Or shall I expect a bottleneck on my read or write i/o? > Platform: > DEC 4000 series 4 CPU running 4.0d OS > Storage Works disk sub system apprx. 100Gb. > INFORMIX 7.3X DS > OLTP expected users 150-200. Oops ! In your case it's better to move critical dbspaces to RAID 1 or RAID 5. Any other data must be stored at RAID 1/0. Storing data on RAID 5 in OLTP system will dramatically decrease performance. RAID 1/0 is optimal for storing data. But in this case if you loose one of the disks, you need to restore this part of data fron your archive. So, you have to think much about your archive devices and archive strategy planning. Storing critical data on RAID 5 or 1 gives you good protection from full system crash because of disk filure. -- With best regards, Yuri Dovgart. Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.