• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

The Secret to Keeping Your Cool Like an Experienced Production DBA

June 25, 2013 by John Sansom 2 Comments

Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major problem.

Things can and will go wrong in your environments. Even the greatest software contains bugs and hardware fails, often.

When an unforeseen issue arises your reaction can directly influence the end result and not necessarily in a positive way.

You must be able to keep your cool under pressure in order to achieve the most desirable outcome.

You’re Playing at the High Stakes Table

HighStakesDBA

DBA Dawg

Panicking in response to a crisis will delay the time to resolution and increase the cost of the outage to the business. Mistakes are more likely to occur if a knee jerk reaction is taken. In extreme cases, you could lose your job. Your company could go out of business. It happens.

As Data Professionals it is we who are responsible for the data assets within our organisations, with those of you working alone perhaps shouldering the greatest responsibility of us all.

I’m fortunate to have first-hand experience troubleshooting critical production issues and coordinating incident response for some of the largest SQL Server environments in the world. I’m going to share with you what I have learned about keeping your cool in a crisis and what I believe is the most vital component to effective incident response.

Game Time

Any serious professional playing in a high stakes game goes into it with a plan to win. Winging it is out of the question because things are just too important to leave to chance.

It’s no different for a Database Administrator and is why I believe that every DBA must have an Incident Response Plan if you’re serious about playing to win.

When problems arise you don’t want to be spending time figuring out what your next action is. You should already know what your first steps are so that you can begin to implement them right away and at the first sign of trouble.

How Will You Respond to Crisis?

When you’ve got an incident to respond to you’re going to want to at least have some sort of plan to follow. Any semblance of a documented plan is better than having no plan at all.

  • What are you going to do when the call comes in?
  • What is the first thing that you are going to look at on your SQL Server instance?
  • Are there any specific queries that you might want to run?
  • Do you have them stored in a readily accessible place?

As you begin producing your own incident response plans and processes, you’ll likely want to start to build a knowledge base of supporting resources, tools and documentation (maybe using a Wiki). A place where you and your team can get at the information you might need during an incident to respond fast and effectively.

Practice mock incident and disaster scenarios in order to put your plans to the test. This will not only give you confidence in the effectiveness of your plan but you will also likely be able to identify opportunity for further improvement.

Planning for Success

Having an incident response plan produced and ready will:

  • Provide a proven structure for you to work from.
  • Enable you to respond swiftly and with precision.
  • Give you the confidence that you’re ready and able to handle whatever challenges might present themselves.

When it’s all kicking off and your boss is hovering around your desk, having a response plan will ensure you keep your cool, remain focused on your task and can deliver the best possible outcome.

Credit: Photo by lawrence used under Creative Commons

Filed Under: Administration, SQLServerCentral Syndication, SQLServerPedia Syndication

About John Sansom

I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy