New answers tagged

4

This isn't a full/distinct answer so much as a detailed explanation of why I favor @Remus's answer, specifically the VM recommendation, that is too long for a comment and not in any way communicated by my upvote of said answer. I worked at a company that had a very similar environment: Federated Farm approach where there was a single data model used on 18 ...


6

A single SQL Server instance knows how to manage its memory, CPU and IO in the most optimal way. Two (or more) SQL Server instances cannot cooperate to coordinate usage of shared resources. On this grounds, a single instance is more performant than more instances. If you split into 2 (or more) instances, then it would be required to partition the resources ...



Top 50 recent answers are included