We are looking to setup multiple enterprise databases in SQL server. Each will contain a specific disciplines data and some will contain reference data. Users of the system will need to use data from many of the databases at one time, creating multiple connections I guess?! We then have multiple services which will use data from many of the databases.
What effect will this, if any, have on performance? Is there configuration we can put in place which will help performance other than the regular database maintenance? Or would we be best to keep the number of databases down and utilize feature datasets for organisation instead?
