维护窗口和停机时间 可用率99.99%
维护窗口和停机时间 可用率99.99%
QQ的可用率是 99.99%
http://www.sqlskills.com/blogs/paul/survey-target-uptime-planned-actual/
t’s been five years(!) since the last time I asked about your target uptimes for your critical SQL Server instances and I think we’d all be interested to see how things have changed.
Edit 6/2/14: The survey is closed now – see here for the results.
So I present four surveys to you. For your most critical SQL Server instance:
- If it’s a 24×7 system, what’s the target uptime?
- If it’s a 24×7 system, what’s your measured uptime over the last year?
- If it’s not a 24×7 system, what’s the target uptime?
- If it’s a 24×7 system, what’s your measured uptime over the last year?
You’ll notice that the surveys are termed in percentages. Here’s what the percentages mean for a 24×7 system:
- 99.999% = 5.26 minutes of downtime per year
- 99.99% = 52.56 minutes of downtime per year
- 99.9% = 8.76 hours of downtime per year
- 99.5% = 1.825 days of downtime per year
- 99% = 3.65 days of downtime per year
- 98.5% = 5.475 days of downtime per year
- 98% = 7.3 days of downtime per year
- 95% = 18.25 days of downtime per year
If your target uptime allows for planned maintenance downtime, then that doesn’t count as unplanned downtime, as long as your system was only down for the length of time allowed. But don’t cheat yourself and retroactively classify unplanned downtime as planned, so it doesn’t affect your actual, measured uptime.
For instance, if you have a 99.9% uptime goal for a 24×7 system, with a quarterly 4-hour maintenance window, then I would select 99.9% in the 24×7 target survey. For that same system, if the downtime was limited to the proscribed 4-hour window each quarter, and there was no other downtime *at all*, I would select 99.999% on the 24×7 measured uptime survey.
Basic advice is to use common sense in how you answer. If you say you have a 24×7 system but you have a 12-hour maintenance window each week, I wouldn’t classify that as a 24×7 system.
24×7 Systems
Survey 1: 24×7 system target uptime
Survey 2: 24×7 system measured uptime
Please be honest. Remember if you choose 99.999% that means you’re saying your system was up for all but 5 minutes in the last year.
Non-24×7 Systems
Survey 3: Non-24×7 system target uptime
Use ‘Other’ to answer if your answer is ‘No target or target unknown’.
Survey 4: Non-24×7 system measured uptime
Please be honest.
I’ll editorialize the results in a week or two.
Thanks!
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· 没有源码,如何修改代码逻辑?
· 一个奇形怪状的面试题:Bean中的CHM要不要加volatile?
· [.NET]调用本地 Deepseek 模型
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· 没有源码,如何修改代码逻辑?
· PowerShell开发游戏 · 打蜜蜂
· 在鹅厂做java开发是什么体验
· WPF到Web的无缝过渡:英雄联盟客户端的OpenSilver迁移实战