Need database splitting advice

From: Joe Condle <condjp_at_chp.edu>
Date: 6 Jun 2002 11:02:24 -0700
Message-ID: <64a5ef9b.0206061002.1a2cb570@posting.google.com>

I have two production databases running off one Compaq 4100. In addition to the two production databases there at least one test db running along with the production databases. This a Peoplesoft installation. There could be more tests db's running other than the normal two.

We will be getting one more 4100 to try and split things off. My question is which the two scenarios is better.

Dedicate one machine per production DB along with it test DB's.
Have one machine for the two production DB's and one machine for test DB's.

I personally lean toward number one, because I can improve performance of the production DB's by shutting down test DB's if I have to.

Any Opinions

Joe Received on Thu Jun 06 2002 - 13:02:24 CDT