• dan-572483 (11/7/2012)


    If you have two beefy 64-bit servers in 2-node cluster, and several applications that need a database server, is it generally better to install multiple instances, or deploy databases for multiple applications on once instances.

    I would think you would use two instances when different applications require a different version/edition of SQL Server, or different server-level configuration settings, you'd install multiple instances.

    But if all the applications support the same edition/version of SQL Server and default database level settings, then I would think that one instance would offer the most effient use of storage and memory.

    Am I right?

    1 instance uber alles. It jsut doesnt make sense to do it any other way, if you dont have to support server versioning.