|
There are a number of questions you need to ask:
- Are the databases related in any way?
- Do you carry out a lot of inter-database transactions?
- What are the databases used for (i.e., are they DSS or OLTP or a mix)?
If the answer to (1) and/or (2) is yes and the workload is similar(ish) then it may be better to consolidate databases. Even if the workload is different then you can look into the "resource manager" to segregate resources. At one site I had five separate but related databases for a very large data warehouse. I combined all five databases into one large one with data still separated out using different schemas. The resultant database, although large, was easy to manage, and the query + load time for the majority of the processes improved.
Regards,
Harish Harbham
|
