Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Consolidation of SQl2008R2 servers to SQL2012?


Consolidation of SQl2008R2 servers to SQL2012?

Author
Message
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47285 Visits: 44392
Just to give you an idea of the work involved in your request...

When I was still consulting I got a request to quote for consolidation of three SQL Servers into one. Three, not the 25 you have. I conducted a full day meeting with the business owner explaining what would go into the consolidation project, the notes on what would be required and the process took about 5 full A4 pages of notes. I quoted a period of 3 weeks to implement benchmarks, analyse results, test and finally implement the consolidation, that's above and beyond the selecting and purchasing of hardware for the final server.

What you're asking is not 10 minutes of work, it's likely to be a 3-4 month project for a top-level database consultant.

Edit: Since you want to upgrade as well, add another couple of months for testing of all of those applications on 2012 and fixing anything that breaks (something always does)


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Jonathan Kehayias
Jonathan Kehayias
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1822 Visits: 1807
Other key considerations that factor into consolidation:

Security - do any apps have fixed server roles like sysadmin as requirements, those usually have to be segregated
Tempdb Usage - in a consolidated server instance, you only get one, so if there is a lot of usage, that can equate to a lot of contention and problems if you don't plan it correctly
Cross Database Dependencies - do groups of databases have to be on the same server for an application to function?
SSIS/Reporting Dependencies - are there SSIS packages or Reports that access multiple databases, that would require changing if you consolidate?

For the VM stuff, unless you know your host configurations, other VM configurations, and the subscription ratios it is next to impossible to expect any kind of performance requirement would be met from a VM.

Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs
Markus
Markus
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1583 Visits: 3679
I also agree with the others. It isn't as simple as we have 25 servers and want to consolidate down to one.. now do it..

You have to find out what each of these do, what usage they have, what is their most stressful time of day.... you might not be able to consolidate them all down to one. YOu also need to look and see if there are any linked servers from one to another. There are a TON of things to highly consider.



DeWayne_McCallie
DeWayne_McCallie
SSC-Enthusiastic
SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)

Group: General Forum Members
Points: 124 Visits: 1187
Why consolidate when you can virtualize and license SQL at the Host level? Maybe several new Cisco UCS-B200-M3 Blades and a nice SAN back end could be in your future (VMware clustered of course)?

We recently completed a yearlong project to “get off” a now unsupported HP Polyserve environment (using VMware) and have no regrets. Like the experts above recommend you can’t just throw this together and expect it to perform without proper design, analysis and testing; however, it is possible depending upon your business requirements and your current environment. An added benefit would be that hardware upgrades will be a piece of cake after you virtualize and you might be able to save some money in SQL licensing too. When you need more power add another B200 to the VM cluster and don’t scrimp on memory!!
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47285 Visits: 44392
DeWayne_McCallie (12/19/2013)
Why consolidate when you can virtualize and license SQL at the Host level?


That's a form of consolidation, multiple physical machines being consolidated into multiple virtual machines on a smaller number of hosts. You still need to do all the baselining, all the analysis, all the testing.

Part of a consolidation project would be to decide whether the consolidation is into multiple databases on an instance, multiple instances on a server or multiple VMs on a host or some combination thereof.


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


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