SQL*Server Database migration question

[sli]

I am involved in migrating two existing production databases on a 4-processor Compaq 5500 box for an application that supports 1500 users (with around 10-15% concurrency). The new environment involves an integrated schema that houses the data from both the previous databases (around 40 tables), along with additional tables (the total tables are around 150). This new environment will be housed on an 8-processor Compaq 8000 series box.

My questions are:
1.) does migrating from multiple databases (on the same server) to a single database inherently reduce the performance?
2.) If there is a reduction in performance, what would it be?
3.) are there any steps that I can take, from a tuning / optimization perspective, to ensure that the performance in the integrated environment is enhanced

Any suggestions would be greatly appreciated

Thanks

 

[foxdev]

I don't think it necessarily reduces performance. The log file(s) which used to server fewer tables will now be serving more, so it might be expected to have considerably more writes. I'm assuming you're on a RAID setup with 8 or more physical drives, so I can't see that the enlarging of the data file(s) would be a major impact.

Robert Bradley

http://www.foxdev.com/