• http://www.chrisyatessql.wordpress.com Chris

    Well done man. That is about one of the best articles I’ve read in the past month.

    “We all spend a lot of time bolstering our knowledge and developing our skills. It’s natural to reach a comfortable place in our assessment of our own abilities but don’t let this develop into overconfidence, which can lead to complacency if not careful.”

    I’ve just shared that with the team.

    • http://www.johnsansom.com John Sansom

      Wow, thanks Chris! I appreciate it.

  • gren

    Its amazing how things can go from ‘normal’ to ‘cluster-feck’ in an instant:


    Your wisdom to make time to stop and think is absolutely bang-on !

    • http://www.johnsansom.com John Sansom

      Ha, indeed! Keeps things interesting right.

  • Dave

    Great story and example of how we need to be prepared for all contingencies when making changes in production. How did you solve the original challenge of adding a new Subscriber? I’m guessing in a 24×7 operation there isn’t a window of downtime to work in.

    • http://www.johnsansom.com John Sansom

      Thanks Dave. You’re absolutely right, it can be challenging finding a suitable time to schedule work of this nature in 24×7 environment. Implementation almost always has to be carried out at the time of lowest traffic.

      In this particular case, timing came into play as much as anything. A subsequent run of the replication stored procedure completed in seconds.

      As an aside there are some things that can be done to “optimize” (used loosely) the process of adding a subscriber. Things such as considering the current workload on the Distributor at the time of the deployment, limiting the number of articles defined within a given Publication etc.

  • Ivan

    Great article, it does remind you of how complex a system can get and how you can overlook this fact by being to overconfident.

    • http://www.johnsansom.com John Sansom

      Thanks Ivan, glad you enjoyed it sir.

  • Herbert TObisch

    Thanks a lot.
    Sometimes I need that.

  • Pingback: 10 Habits of Sucessful Senior DBAs that You Can Use Today • John Sansom()