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

Is 0% Downtime Possible? Expand / Collapse
Author
Message
Posted Thursday, February 7, 2002 12:00 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Wednesday, October 22, 2014 12:34 PM
Points: 31,181, Visits: 15,626
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/is0downtimepossible.asp






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #2543
Posted Monday, February 25, 2002 2:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:28 PM
Points: 2,908, Visits: 1,834
The problem is that management believes in 0% downtime. Fortunately, they have 50% downtime so its not too hard to sync downtime where they won't notice.

The worst case of downtime was when some muggins switched off a server that had been happily running for 3 years solid. Once it had cooled the raid array had seized solid. Oh, and when they came to do the restore they found it had never been included on the back-up schedule for the network.



LinkedIn Profile
Newbie on www.simple-talk.com
Post #27771
Posted Monday, February 25, 2002 4:38 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Monday, October 20, 2014 1:24 PM
Points: 8,370, Visits: 743
The only thing you should have added is where you measure your downtime, 1 day, 1 month, Mon-Fri 8 to 5. We set our service levels based on tiem frames for each database and it's related applications not a general note of downtime. Other that grat simple article.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)



Post #27772
Posted Monday, February 25, 2002 7:07 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 9:05 AM
Points: 976, Visits: 59
Good article. I agree, 0% downtime is impossible. I liked David.Poole's comments on planning downtime when no one will notice. We do this all the time. Many of our rollouts of new features happen between 11PM an 1AM. This is when we have almost no one on our site and so, no one notices our planned downtime for changes.

Robert Marda




Robert W. Marda
SQL Programmer
Ipreo
Post #27773
Posted Monday, February 25, 2002 11:17 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Wednesday, October 22, 2014 12:34 PM
Points: 31,181, Visits: 15,626
Thanks guys, I have long felt that it was impossible overall and have adopted the items mentioned. There is always some maintenance window, sometimes on the spur of the moment .

I've tried and haven't figured it out. If the telco's can't do it over years, I figure it can't be done.

I agree with Antares that you have to build some downtime into your SLAs to handle this. BTW, I've worked with 7 long haul carriers and 5 co-location/managed service companies. Not one of them has 100% uptime for the network over a year.
Oh well...

Steve Jones
steve@dkranch.net







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #27774
Posted Monday, February 25, 2002 11:27 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Monday, October 20, 2014 1:24 PM
Points: 8,370, Visits: 743
I worked previously with a telco and was suprised by how much the networks went down without anyones knowledge but the techs. A lot tracking goes on to keep in progress calls from dropping when a fiber cut occurrs and it almost instantly reroutes to another available circuit while carrying the call.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)



Post #27775
Posted Monday, February 25, 2002 11:59 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Wednesday, October 22, 2014 12:34 PM
Points: 31,181, Visits: 15,626
They have fantastic rerouting and fault tolerance. BUT, there is still downtime and not just my local circuit. Mostly I deal with data, but I have seen minutes to hours of downtime for links without rerouting, mainly when there are
1. a single route for an area. A good example was about five years ago ATT had a tremendous amount of frame traffic running from CA to the East through Las Vegas. The two fiber lines in the ring were physically close together and both were cut. Hours of downtime for frame customers.
2.Upgrades. Seen numerous cases with colos when a major router upgrade occurs, could be softare or hardware, there is a loop that occurs and the routers flap between themselves, sometimes cutting off large blocks of IPs. The 4-8 carriers supplying connectivity don't help here.

Steve Jones
steve@dkranch.net







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #27776
Posted Tuesday, February 26, 2002 4:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 9, 2006 11:00 PM
Points: 19, Visits: 1
Every kid knows that the absolute is unachievable. Question is how long downtime can be for 24x7 system? My record - 1 hour downtime in six months.




Post #27777
Posted Tuesday, February 26, 2002 7:07 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Wednesday, October 22, 2014 12:34 PM
Points: 31,181, Visits: 15,626
For SQL? I've run over 5-6 months on v6.5 with no downtime. Haven't really pushed the envelope on Ss2K, though I'd have to check my current box.

I used to run a Novell network (> 1400 nodes) and we had a server used by the Operations department for logging information. Best run I know of, > 500 days.

Steve Jones
steve@dkranch.net







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #27778
Posted Tuesday, February 26, 2002 9:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 16, 2007 8:25 AM
Points: 2, Visits: 1
OK, so we're all pretty much in agreement that true 0% downtime is not achievable. Some have suggested that maybe we need to change the way we measure downtime. This is not just a fancy cop-out, but a recognition that 'downtime' at midnight may not really be downtime because the system is idle. I would like to add to that the idea that planned downtime may not really be downtime. I'm familiar with a few industries where full plant shutdowns are implemented for maintenance and upgrades and nobody counts this as downtime! Presumably, the expense and lost business are more than recovered through more stable, more efficient, and/or higher capacity systems.
What we really need is a way to 'profile' our downtime that takes into account user requirements, business requirments, presumed advantages associated with maintenance and upgrades, workload balancing, etc. Any ideas?




Post #27779
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse