November 7, 2012 at 10:33 am
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 server level settings, then I would think that one instance would offer the most efficient use of storage and memory.
Am I right?
November 7, 2012 at 10:54 am
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.
November 7, 2012 at 11:52 pm
It depends. There are good reasons for each alternative and not enough information to say which is better.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 8, 2012 at 9:31 am
In this case all applications will support the same edition/version/patch level. No conflicting instance-level settings are needed and Transparent Data Encryption will not be used. I'm also confident security can be designed to keep vendor support out of other vendors' DBs.
What other factors would make multiple instances a better choice?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply