Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Uptime = Downtime? (Database Weekly, Aug 3, 2009)

By Steve Jones,

While scanning the headlines this past week, I came acoss this sentence in the opening paragraph of one article: Is the pressure to be “always on” leaving data center power systems more vulnerable to failure?

That really caught my eye, and in terms of mechanical systems, and even electrical connections, it makes sense. There is a certain amount of maintenance that you need to do in order to ensure things keep running. Your car needs regular oil changes, your house might need regular painting, even your bike chain needs a little grease now and again.

There are plenty of systems that continue to function without maintenance, but they degrade. Your HVAC system will keep running even if you change filters once every 3 years, but it will not run as efficiently and it will cost you more money than it needs to. As a suggestion, I set a reminder in Outlook to change filters every month. Your computer is the same way in that it will keep running even if you never clean out the case, but at some point those dust bunnies might cause you a premature failure from heat.

In a data center, there are definitely recommendations for handling the various supporting systems, and the article mentions that electrical connections need to get checked, along with other items. There is concern that the constant demand for uptime might contribute to larger-scale failures from a lack of maintenance, and that should be a concern. It has me wondering if my co-location center is actually doing the maintenance that is needed to ensure they'll keep running.

However it also had me wondering about software. Our code doesn't need a checkup, per se, but it might need some maintenance. There might be things that are slightly broken, or they cause minor issues. If we delay fixing things, especially those items with a low probability of occurring, but a high possibility of impact to the system, are we asking for trouble?

It's hard with software to determine how much and how often maintenance is required, but I do think that there are definitely times we defer mainteance for various reaons and eventually cause downtime.

Steve Jones

Total article views: 93 | Views in the last 30 days: 1
 
Related Articles
FORUM

scom System Center Server Management for sql

scom System Center Server Management for sql

BLOG

Denali – Day 27: System Center Advisor (aka ‘Atlanta’)

Denali – Day 27: System Center Advisor (aka ‘Atlanta’) As Microsoft is working more on Cloud base sy...

BLOG

Microsoft System Center Advisor (Release Candidate)

Microsoft’s Brad Anderson announced the availability of the Release Candidate of Microsoft System Ce...

FORUM

system center operations manager to monitor SQL server

system center operations manager to monitor SQL server

ARTICLE

Portable Data Centers

Is the next data center for your SQL Servers going to be portable? Steve Jones comments on some of t...

Tags
database weekly    
editorial    
uptime    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones