I am building a new database server that should host many databases serving many applications. I have two strategies to setup the server but am still undecided. which one should I use for better utilization.
1. Single instance that host ALL the databases
2. Multiple instances identifies with each having subset of the databases.