Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 8:57 AM
Points: 398, Visits: 271
Hi,

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,

hash_561

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: Friday, April 18, 2014 12:58 PM
Points: 367, Visits: 614
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: http://technet.microsoft.com/en-us/library/ee819082(SQL.100).aspx
Post #967558
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse