How to find the Golden Ratio of databases per given resource?
- From: Charles Schultz <sacrophyte@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 3 Mar 2009 13:48:59 -0600
Good day, list,
In our environment, we try to cut corners and save a few bucks by attaching
a number of hosts to a small number of EMC SANs. The question (rather,
questions) has come up as to what thresholds exist that would determine how
many databases can/should go on each host, and how many hosts can/should be
attached to a given array. For example, we have a development environment:
- Sun F15k, 40 GB RAM, 20 CPUs, Solaris 10
- 10.3 TB of disk for databases
- 26 databases
I am not exactly familiar with all that is hooked up the SAN, but from time
to time the load from one host will significantly affect the other hosts
(especially during database clones or parallel file copies). We have three
groups who jointly manage the back-end infrastructure (Storage, Sysadmins,
DBAs), with very little crossover in job knowledge/skillset. The hosts are
generally allocated by functional area or application; thus, all of one
application's developement environment will reside on one host, seperated
physically at the host level, but usually joined at the SAN level.
Are there established so-called "Best Practices" that outline how to
architect such an environment, or a white paper that might go into details
(ie, stripe levels, how to spread load, what limits to be aware of, etc)?
Any out there who wish to speak from experience? *grin* I am hoping to get a
question into Kevin Closson and Christian Bilien, but both men are quite
busy.
Any and all help would be greatly appreciated.
Thanks,
--
Charles Schultz
Other related posts:
