Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Server Consolidation candidates Expand / Collapse
Posted Wednesday, August 11, 2010 6:52 AM


Group: General Forum Members
Last Login: Wednesday, June 1, 2016 12:24 PM
Points: 441, Visits: 365

How can I determine/decide on what factors consolidating the databases would be best in SQL Server. I know a lot of them like HA, Compatibility, security etc. But what would be the best approach in an environment where there are databases related to different kinds of applications.

Also how can the determine the ideal/best candidates for SQL Server Consolidation.

Thanks in advance,


Post #967363
Posted Wednesday, August 11, 2010 9:54 AM

Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 3, 2016 3:17 PM
Points: 373, Visits: 644
You really need to look at each DB separately as to resource usage and maybe size.

Then you have to ask which consolidation method is best for the DB.

If the DBs are similar in nature and function, then consolidating into a single DB, perhaps using schemas, may be best.

Other factors, including security, that are kind of beyond the scope of a quick forum answer can result in consilidating multiple DBs on a single instance, creating multiple instances for each DB, or set of DBs, or using virtualization.

This is an article that gives a pretty decent overview:
Post #967558
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse