Debate: Multiple Instances vs Single Instances on SQL Servers
Debate: Multiple Instances vs Single Instances on SQL Servers

A debate that is common among DBAs and possibly Architects, is whether should an organization use the what-so-called “SQL Instance Stacking” in order to deploy more than one SQL instances under the same OS, usually a Windows Server system. Let’s just see the advantages and disadvantages listed below: Pros Benefits Consolidation as several systems can... » read more