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

Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, trainer, and SQL Server MVP with over a decade of experience. Tim is the principal of Tyleris Data Solutions and is a Linchpin People teammate. Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. He is a board member at the North Texas SQL Server User Group in the Dallas area. Tim 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 twitter.com/Tim_Mitchell.

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.

Comments

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.