> One of our customers is running a largish (6 GB and growing) > MaxDB 7.5 (on Linux) instance on standard server hardware. > The installation suffers from the MaxDB "feature" of slow > index/table scans (about 900 kbyte/s on this machine with > disks that could deliver 40MB/s). > > They are about to install a HP EVA 4000 SAN which we could > connect to with a Fibre Channel link. > > The question is: Will this improve performance "out of the > box"? Is such a SAN something MaxDB can be tuned for? I've > heard rumors that there is hardware the DB doesnt read that > slowly from. Does anyone here have experience with this?
HP 4000 is the successor of HP 3000 on which we are running all our SAP applications. Performance is faster than with direct attached SCSI, no doubt, but all our MaxDB production system don't max out the maximum throughput of the EVA. For maximum throughput it's advisable, to have the largest CACHE_SIZE possible. If your DB is 6 GB, I'd buy a cheap Opteron or EM64T-Box with 8 GB so you can put the whole database into the memory and so minimize the physical disc accesses. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
