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

Gone Dark

This afternoon was quite interesting around the office.  A strong thunderstorm moved through the area, a common occurrence in Texas during the spring.  However, this storm took out a critical transformer nearby and knocked out the power grid for some time.  Our emergency generators roared to life without a hitch, and critical systems stayed online on supplemental power until electricity was restored an hour or so later.  One glitch was observed in cooling: the air in the NOC was running but the cooling unit was not.  Fortunately, the outage did not last long enough to increase the temperature to a critical level.

We run tests on these types of events – in fact, our facilities staff tests the generators on a semimonthly basis, and we actually fail over to the backup power during those tests.  It has been some time since we’ve run on backup power for more than a few minutes.

In my corner, I was particularly thankful for the desktop UPS unit I have running.  It’s small and aging, and doesn’t have the longevity it used to, but it allowed me more than 20 minutes to finish up what I was doing and shut down my computer properly.  I did notice that my speaker system and desk lamp are both connected to the UPS, which is an unnecessary drain on the battery.  Time to crawl in the floor and rewire.

Nobody likes to run power failure tests, and it’s even less enjoyable to run this drill for real.  But in times such as these, it’s good to know that your backup systems are regularly tested and sufficient to continue critical operations.

Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, trainer, and Microsoft Data Platform MVP with over thirteen years of data management experience. He is the founder and principal of Tyleris Data Solutions.

Tim has spoken at international and local events including the SQL PASS Summit, SQLBits, SQL Connections, along with dozens of tech fests, code camps, and SQL Saturday events. He is coauthor of the book SSIS Design Patterns, and is a contributing author on MVP Deep Dives 2.

You can visit his website and blog at TimMitchell.net or follow him on Twitter at @Tim_Mitchell.


Posted by Steve Jones on 26 March 2009

It's a white out here today, and so far we have power.

We have a generator at the house, it runs every Tues at 3:30 for a 5 minute test. I usually hear it, and I have a reminder to check the propane levels every 2 weeks. So far it's worked well and saved us a few times when we really needed power.

Leave a Comment

Please register or log in to leave a comment.