Multiple Instances or Single Instance?

SQL Server DBA's and Developers need to decide how to partition databases when running multiple databases on a single server.

This TechNet article has guidance on whether multiple instances or a single database makes the most sense. I have never been a fan of multiple instances. One problem (less of a problem these days I expect) is that some clients will not have the underlying drivers to allow them to work with multiple instances. The second problem is the general confusion over what is in which instance of the database.

Posted by Douglas Reilly at 10:07 AM  Permalink