SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Consolidation candidates


SQL Server Consolidation candidates

Author
Message
dba.asiff
dba.asiff
SSC-Addicted
SSC-Addicted (445 reputation)SSC-Addicted (445 reputation)SSC-Addicted (445 reputation)SSC-Addicted (445 reputation)SSC-Addicted (445 reputation)SSC-Addicted (445 reputation)SSC-Addicted (445 reputation)SSC-Addicted (445 reputation)

Group: General Forum Members
Points: 445 Visits: 365
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
jerry-621596
jerry-621596
Right there with Babe
Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)

Group: General Forum Members
Points: 721 Visits: 648
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search