Avatar of Bhavesh Harsora
Bhavesh Harsora

asked on 

Which is better to go either SQL Server multiple Instances each have a database or Multiple databases in single instance.

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.
SQLDatabasesMicrosoft SQL ServerMongoDB

Avatar of undefined
Last Comment
Vitor Montalvão

8/22/2022 - Mon