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 12»»

Consolidating Again and Again and Again Expand / Collapse
Author
Message
Posted Wednesday, November 11, 2009 8:28 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:06 AM
Points: 33,204, Visits: 15,355
Comments posted to this topic are about the item Consolidating Again and Again and Again






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #817583
Posted Thursday, November 12, 2009 5:02 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, June 20, 2012 5:02 AM
Points: 530, Visits: 945
On the subject of consolidating SQL Server instances, we have the opposite problem of trying to arrange separate groups of databases on one machine. This is really just get round the fact that SSMS doesn't allow you to group them visually in Object Explorer. Are instances the only way to achieve this, e.g. to separate out production and testing databases?
Post #817725
Posted Thursday, November 12, 2009 7:04 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:16 AM
Points: 1,270, Visits: 2,784
The company I work for was bought out so both of our companies are going through an analysis phase of consoldiation. We have more SQL Servers and databases here but they have alot as well. Over the last three months we have identified older less used servers that we can move the databases to existing beefier SQL Servers and eliminate licensing and hardware. So far we have made good progress and are about half done. Going forward all applications instead of using the servername use a dns alias which in the future will make it easier to 'move' an applications databases to another server for either further consolidation or just upgrading. All you do is move the dbs/logins/jobs and change the dns alias. No code changes, no searching to figure out how the app points to the SQL Server.


Post #817808
Posted Thursday, November 12, 2009 9:31 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, August 22, 2014 9:27 AM
Points: 717, Visits: 689
One 'could' argue that the long term cost savings in virtualization/consolidation is not having to maintain the hardware you didn't buy. The three year hardware replacement cycle savings would be huge over the long term.
Post #817931
Posted Thursday, November 12, 2009 9:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 15, 2014 3:04 AM
Points: 2,728, Visits: 1,116
Worked on a lot of consolidation projects, seems to be more the latest buzz word rather than a concept that gives consistent results to the business. Unless it is planned properly it can be more of a cost loser rather than cost saver. maybe i'm too jaded and cynical, seen too many screwups in the pursuit of cost cutting projects by bean counters, voicing the usual words. consolidate, consolidate, consolidate.

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #817938
Posted Thursday, November 12, 2009 10:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:16 AM
Points: 1,270, Visits: 2,784
I think there needs to be a healthy balance in any consolidation effort. We have a TON of servers in our datacenter that run one app or host one or two small databases and the resources on that hardware average under 10% utililization. If you pick and choose the right things to consolidate it can be benefitial and make everyones job easier as you have less physical hardware to maintain and keep up to date. If you take the opposite approach and just pick things and 'force' a consolidation just to consolidate you are in putting the company at risk. We have already consolidated some small apps/databases and the consolidated servers you cannot even tell there is much more load on them. We had too many projects over the years come in and say we need X number of servers for this and that and we SHOULD have stepped in and said what are the requirments and prove you need seperate hardware first.


Post #817958
Posted Thursday, November 12, 2009 10:16 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:06 AM
Points: 33,204, Visits: 15,355
We had hundreds of instances at JD Edwards, and make regular efforts to consolidate things. We did not take a "everything should be consolidated approach", but rather identified underused instances, talked to business owners/clients, and then regularly would move databases together and retire old hardware or repurpose it.

There's nothing wrong with bean counters driving it, you just need IT to make good decisions and not buckle under to pressure to just combine things.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #817965
Posted Thursday, November 12, 2009 10:46 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, July 14, 2014 10:08 AM
Points: 754, Visits: 3,816
For years I've been frustrated how often new servers were needed. "You have to add 2 + 2? OK, we'll need another server for that. "

So it's no surprise to me that now we need to talk about server consolidation.

Stick around long enough and you'll see IT go 'round in circles.


______________________________________________________________________
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
Post #817985
Posted Friday, November 13, 2009 7:11 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
Virtualization can save money on an ongoing basis. As already mentioned, less maintenance and upgrade cost because of less hardware. Even more so, when done correctly, it can keep apps and databases up and running despite hardware failure on a server, which serves much the same purpose as clustering/mirroring, but without the "we have a server that just sits around doing nothing but prepare for disaster". Keeping apps and web pages and databases up and running, instead of allowing for downtime, can save a company a lot of money in terms of preventing lost opportunities.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #818476
Posted Friday, November 13, 2009 11:18 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: 2 days ago @ 9:58 AM
Points: 36,995, Visits: 31,517
Still, mirroring, log shipping, or what have you to a server a couple of hundred miles away will save your company's hiney if your building is flooded, get's hit by a tornado, gets burned to the ground, blown up by a nut, or anything else that would take out the important parts of the server room.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #818747
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse