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 Expand / Collapse
Author
Message
Posted Sunday, January 25, 2009 11:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:13 AM
Points: 330, Visits: 960
Hi,

I would like to know in detail how to acheive sql server consolidation, i have no idea about this, why do we do this and how to acheive this, but i have told to work on this, please let me know.


With Regards
Dakshina Murthy
Post #643208
Posted Sunday, January 25, 2009 12:43 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
First thing for you to do is to understand what is management asking you to do.

My wild guess is that you have several SQL Server boxes in your shop and somebody has the brilliant idea of "consolidating" all or some of them in a smaller number of servers. Do you get the idea?


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #643222
Posted Sunday, January 25, 2009 12:44 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 8:52 AM
Points: 494, Visits: 855
SQL Server consolidation simply means taking databases, services, jobs etc. housed on a proliferation of SQL Servers and migrating them to one or more large centralised SQL Servers.

The objective of doing this it to reduce server headcount, thus saving money on hardware, software, licensing, administration, and support overhead.

Post #643223
Posted Monday, January 26, 2009 6:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 24, 2014 11:20 AM
Points: 31, Visits: 340
Here are some tips to start with. This is going to take time.
Find out where all the servers are?
What is on those servers?
Who has access to them?
Do they still use the data that is on the servers?
How much data is on each server?
Are the servers you currently using able to expand their usage?
Plan to create different SQL Instance for the different data sets. This will help if you have to stop the services of a data set and not effect others.
Look at the usage of each of the old servers and determine which are just file servers, print server, SQL server, Application Servers, Backup Servers,
Break them down into groups of common usage and then plan on what can be combined.
As for archiving data, determine what is the time frame that they are willing to wait to bring the data back on line to determine if it can be archived.
Post #643394
Posted Monday, January 26, 2009 6:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 24, 2014 11:20 AM
Points: 31, Visits: 340
Here is a link for some other helpful information. It was setup for SQL2K but process still applies

http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/sql2kcon.mspx

Post #643398
Posted Monday, January 26, 2009 9:39 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 8:52 AM
Points: 494, Visits: 855
That's a really good link.

I can see the cut-and-pasteability of that being very useful if faced with the task of writing a business proposal for SQL Server consolidation.
Post #643524
Posted Monday, January 26, 2009 3:03 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 24, 2014 11:20 AM
Points: 31, Visits: 340
I used the process to work out an outline for other servers as well.
Post #643726
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse