What are the pros and cons of running more than one instance of SQL Server on a single physical server?

Running multiple instances of SQL Server on the same physical server should generally be avoided because each of the instances will have to fight over hardware resources, hurting the performance of all the instances.

Generally speaking, there are two reasons why you might want to run multiple instances on the same physical server.

1) You want to have multiple instances of SQL Server for development and testing, and you have a physical server that will handle these instances without performance issues.

2) You are faced with a situation (like a web hosting company) where you need to run many instances of SQL Server (because each one has a different administrator), and the instances are not very busy, and the hardware is powerful enough to run all of the instances without performance issues.




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |