Re: 10g RAC: max performance & min cost with miSCSI?

About the application: we are running a multi-purpose consolidated database which have everything you can imagine of: access from web applications, queries issued from SQL*Plus and Discoverer, some large batch inserts/updates. The database size is currently about 300 GB and is excpected to be remain under 700 GB which is the maximum capacity of 20 mirrored 73 GB disks. We could also use 146 GB 15k disks to double the storage capacity. The database is read intensive so over 90% of operations are reads. But we can't ignore the write performance since there are a couple of large long-running patch updates. I can't give you exact numbers what is the requirement for IO peformance since there are no exact numbers. Currenlty the users are quite happy. What I want now is to put the new system up so that the performance will be blistering at the beginning and remain tolerable for four years.

I am planning to put 8 GB RAM to both RAC nodes, or maybe 12 GB to be safe. The processors on the nodes will be the fastest available single core Xeons or AMDs. Multi core seems to be out of the question since Oracle has this stupid licensing model.

I have now come up with another storage system proposal. We could use MSA500 units. We need two of them and both with High Availability Kit. MSA500 list price is about 4500 euros and HA kit is 4000 euros, so we need to pay 17000 euros for the disk units compared to 8000 euros when using MSA30 MI. MSA500 & HA kit includes all needed HBA PCI-X cards and offers possiblity for "hardware raid". And now we can use Xeon/AMD servers instead of going up to Itanium. Assumably two MSA500 units can give similar IO speed than two MSA30 MI units since the internal structures are similar (two U320 SCSI busses, 7 disk slots each). What I don't know is how will the storage processor of MSA500 perform. It could be the bottleneck here. I have been warned that the storage processors of these cheap disk systems are quite slow. I have read that MSA1000 with two SPs runs the SPs active-passive, so only one SP is active. It could be same thing with MSA500 with dual SP's (HA kit). So what we have is two MSA500 both having one SP active. Can a MSA500 storage processor deliver the required 250 MB/s to get total 500 MB/s of IO?

--
Heikki