August 11, 2010 at 6:52 am
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
August 11, 2010 at 9:54 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply