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


The High Availability Poll


The High Availability Poll

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (282K reputation)SSC Guru (282K reputation)SSC Guru (282K reputation)SSC Guru (282K reputation)SSC Guru (282K reputation)SSC Guru (282K reputation)SSC Guru (282K reputation)SSC Guru (282K reputation)

Group: Administrators
Points: 282288 Visits: 19908
Comments posted to this topic are about the item The High Availability Poll

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
C64DBA
C64DBA
Valued Member
Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)

Group: General Forum Members
Points: 67 Visits: 429
Working in the legal industry, I can say that there is both a desire and the resources to make HA real. The last firm I worked for runs 2 large 2-node active/passive clusters. One of which was entirely dedicated to the billing system. The other mostly for the DMS but also sharepoint. Towards the end of my time there, they started to implement an off-site HA capability. Basically a simple fail over for the Blackberry database and Exchange server to ensure email would continue.

The firm I currently work for have gone entirely offsite. All SQL servers are running in virtual instances. The SANs are diffed off-site with equal hardware running the same VMs. Downtime for a complete fail over is a few minutes. Because of this, there is no other HA implemented. No clustering or mirroring or replication.
Dave Poole
Dave Poole
SSC-Dedicated
SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)

Group: General Forum Members
Points: 30161 Visits: 3612
Desperately important AFTER an incident occurs that involves lack of availability.

LinkedIn Profile
www.simple-talk.com
sqlstad
sqlstad
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1344 Visits: 669
Working in the energy industry, the business units don't require us to be able to recover instantly with HA options.
The fact is that this isn't a business continutity decision but a decision based on costs of the hardware and software.

It has been a real pain for me to convince the business units to take a good look at the possibilities and make a decision for the business continuity.
No success so far.

I guess the shit really has to hit the fan before decisions like this are made based on the right reasons.


call.copse
call.copse
SSCrazy Eights
SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)

Group: General Forum Members
Points: 8043 Visits: 2108
I will happily join the cynics here and say we will implement HA after serious costly downtime. It doesn't seem to be terribly likely as our team have rarely lost anything important for any length of time. In this case, I think you need high penalties for an hour or so of outage (which you might otherwise occasionally encounter) or not be adequately organised to recover quickly.
Jakub.Janda
Jakub.Janda
SSC Eights!
SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)

Group: General Forum Members
Points: 922 Visits: 455
Highly available database is a must for us (a large eshop). We used failover clustering but are going to move to AlwaysOn in a few weeks.
IceDread
IceDread
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1705 Visits: 1145
It is very important to us or my employer. I work for a large insurance company that is active in Scandinavia, the northern Europe. The department i work for is responsible for the large customers and it's very important that they can create insurances on the fly and have our support and knowledge available. We want our customers to succeed, that also is good for our business.
The Sinister Minister
The Sinister Minister
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 29
In the Lottery industry, 100% availability is paramount. Our company has likely invested as much time and money on HA database and system functionality as it has on actual software development. Noone wants to hear "Sorry, the Lottery is down" when there's a $100 million jackpot on the "line". Smile
Summer90
Summer90
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14628 Visits: 3920
We have hardware up and running with databases all setup and configured at out DR site. In the event of a disaster we'd recover the dbs from our de-dup backups at that site. Our system owners are OK with a few hours of downtime in order to recover the dbs as they are not that critical to our business. I don't think I could ever convince senior mgt to spend the big extra cost of Enterprise Edition to get Always On. We are just now going to SQL2008R2 for these databases so we probably won't even go to SQL2012 and just skip it and go with SQL2015 anyway.
David Benoit
David Benoit
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15922 Visits: 3650
Yes, my company sees it as critical for both HA and DR.

We use a combination of technologies which include clustering and scaled out replication for HA and other technologies for DR.

The biggest thing to determine in all this is the TRUE need and the amount of time that you can be offline and then engineer a solution to meet those requirements. There are a myriad of options, even some homegrown that are better than nothing. Sure, your downtime might be longer with some of those options but that may be totally acceptable in the industry that you are in.

In reality all companies have a need. And there are always ways to get a solution in place, even on a very limited budget. We as DBA's just need to convince them to invest the time in getting something in place. :-D

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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