Re: Multiple schemas versus multiple databases

One concern I always have about combining multiple applications in the same database is tuning. You tune the whole database, so you could run into the situation where you enhance the performance of one application at the expense of the other. It's not real likely for similar applications, say two OLTP apps, but if you have an OLTP application sharing a database with an application that crunches out a lot of reports, you can see how that could be an issue.

Also, I'm sure your multitude of vendors would never point a finger at the other apps should a problem arise!

My 2 cents.

gag wrote:

> Subject: Multiple schemas versus multiple databases
>
> I am looking for any information concerning experiences (opinions are
> also welcome) of having two COTS packages running in the same database
> versus separate databases on the same server. The server is an HP T600
> 4cpu with 1.2G RAM running HP-UX 10.20. The COTS packages are
> PeopleSoft's HR system and Resumix's human skills management system.
> A third possible COTS package that could be introduced into this system
> is Deltek's Financial application Costpoint.
>
> Thanks!
>
> Gary A. Gregorich
> ggregori_at_arinc.com
Received on Thu Jul 23 1998 - 19:58:33 CDT