Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!wn13feed!worldnet.att.net!128.230.129.106!news.maxwell.syr.edu!postnews1.google.com!not-for-mail From: joel-garry@home.com (Joel Garry) Newsgroups: comp.databases.oracle.server Subject: Re: HP "Autoraid" Performance Date: 2 Feb 2004 16:51:31 -0800 Organization: http://groups.google.com Lines: 43 Message-ID: <91884734.0402021651.4f1defcf@posting.google.com> References: NNTP-Posting-Host: 67.116.125.178 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1075769492 5846 127.0.0.1 (3 Feb 2004 00:51:32 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 3 Feb 2004 00:51:32 +0000 (UTC) Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:253510 alcesteatxmissiondot@com.or.net wrote in message news:... > Recently got an HP VA 7110 Disk Array with ten disks to run a > development database on. This time around, I'm going with the > "stripe and mirror everything" philosophy. When the HP tech was showing > me the system, I was given the choice between Raid 1+0 and "Autoraid." > > At first I assumed this was a funny name for RAID 5, but it turns out > that no, it was more than that. It seems to be a system that uses > either a raid 1+0 or a raid 5 with an additional parity area, depending > on the disk access characteristics. > > Here's a paper that talks about it...not sure how current the information is: > > http://www.hpl.hp.com/research/ssp/papers/Voigt1998.pdf > > The information I can find touts the system's performance over RAID 5, but > I'm not finding any data that compares it for OLTP databases against > a striped and mirrored configuration. > > Anyone used this or looked at it? What do you think? > > Jer Smith It is _very_ dependent on configuration and patches. I have one older machine that just runs so bad and I don't have time to sit down and install glance and futz around and figure out why and futz with the working set. Easier just to replace the autoraid with hand-me-downs from the bigger machines as they get upgraded. Development machines seem to get that a lot, eh? Every installation I've seen seems slow, although it is likely that the installations I've seen are skewed towards "not well administered", since they are usually packaged apps installed by those who wouldn't care about such things as disk and tablespace layouts. And I've even seen it replaced by RAID-5 arrays with better performance. Sometimes "just throw hardware at it" is a reasonable choice. jg -- @home.com is bogus. So glad I got HDTV. http://www.signonsandiego.com/news/uniontrib/mon/splsect/news_mz1x2cbs.html