SQL Server Blog

Can’t Troubleshoot? Don’t Apply!

[et_pb_section admin_label=”Section” global_module=”2469″ fullwidth=”on” specialty=”off” transparent_background=”off” background_color=”#ffffff” allow_player_pause=”off” inner_shadow=”off” parallax=”off” parallax_method=”off” padding_mobile=”off” make_fullwidth=”off” use_custom_width=”off” width_unit=”on” make_equal=”off” use_custom_gutter=”off”][et_pb_fullwidth_post_title global_parent=”2469″ admin_label=”Post Title” title=”on” meta=”on” author=”on” date=”on” categories=”on” comments=”on” featured_image=”off” featured_placement=”below” parallax_effect=”on” parallax_method=”on” text_orientation=”left” text_color=”dark” text_background=”off” text_bg_color=”rgba(255,255,255,0.9)” module_bg_color=”#152f3e” title_all_caps=”off” use_border_color=”off” border_color=”#ffffff” border_style=”solid” title_font=”|on|||” title_text_color=”#ffffff” meta_text_color=”#eeeeee”] [/et_pb_fullwidth_post_title][/et_pb_section][et_pb_section admin_label=”Section” fullwidth=”off” specialty=”on”][et_pb_column type=”2_3″ specialty_columns=”2″][et_pb_row_inner admin_label=”Row”][et_pb_column_inner type=”4_4″ saved_specialty_column_type=”2_3″][et_pb_image admin_label=”Featured Image (700×394)” src=”https://straightpathsql.com/wp-content/uploads/2011/05/BrokenCar.png” show_in_lightbox=”off” url_new_window=”off” use_overlay=”off” animation=”off” sticky=”off” align=”left” force_fullwidth=”off” always_center_on_mobile=”on” use_border_color=”off” border_color=”#ffffff” border_style=”solid”] [/et_pb_image][et_pb_text admin_label=”Blog Post” background_layout=”light” text_orientation=”left” use_border_color=”off” border_color=”#ffffff” border_style=”solid”]

Quick 2016 Update: This is an older post of mine, but everything in it holds true today. As a SQL Server consultant, it rings more true. As a business owner, I really can’t hire someone without the troubleshooting skills folks need to have. I’d rather someone who can troubleshoot than someone who is a guru with SQL Server honestly. 

If you can’t troubleshoot, you can’t work with me (if I can control it anyway). When I am interviewing you I am judging your troubleshooting skills as much as your SQL Server knowledge – if not more depending on the role. I’ve blogged a bit about troubleshooting (Methodology, Trusting Empirical Evidence) and wrote a SQL Server Central Article on it.

A couple weeks ago I almost threw out my shoulder patting myself on the back after replacing the starter in my truck. Up to that point the most complicated thing I’ve done to a vehicle is changed a battery, tire or fuse. I’ve changed the oil once or twice (in my lawn tractor…)  I won’t spike the football  by talking too much about the fix here but I wanted to talk about the steps that brought me to the realization that I was going to be changing into my dirty clothes and lying down under my truck for a couple hours. Those steps followed the methodology I discussed before and effective troubleshooting has been on my mind as I prepare for my SQL Rally presentation on Professional Development (Iceberg, Dead Ahead!)

SQL Server Troubleshooting – Same Steps For Cars:

I Identified The Problem

The Results of My Troubleshooting - A Bad Starter Gone
Out with the old..

I’ve had some intermittent issues with starting but jump starting, waiting or jiggling wires (not a proper methodology but a good quick step each time I had an issue) solved it each time. Well the day it looked serious I had the whole packed into the truck to go get some garden stuff. Even struggled with an infant car seat move from the van to the truck.

My first reaction was problem solving (rushed and inefficient problem solving). That looked like sighing, rushing, jump start attempts, jiggling wires, tightening battery terminals, etc. It was messy and shotgun like. My wife gave me that look and I knew to stop and move everyone to the van for our trip instead of sitting there trying to solve the issues.  I forgot to fly the plane and pay attention to the big picture.

This let me troubleshoot a bit more slowly and carefully later in the day without a family sitting in a hot truck. Here’s what I did while calm to identify the problem:

  • Think – How does a truck start? The 100 level of it (where I am) is –  the key turns and, if the battery is good & transmission is in Park or Neutral (and truck knows it), electricity flows through the battery to a starter. That starter spins fast and starts the engine. So electrical flow is critical, some switches and relays are critical. Fuel helps, I hear.
  • Rule Outs – I ruled out the issues in order of “obvious problems” and easier to fix:
    • Fuel – Engine wasn’t even trying to turn over, just clicking. Starter wasn’t spinning the flywheel.
    • Battery – Tested, no issues. Terminals looked fine, connection tight.
    • Fuses – Fine
    • Relays – Starter relay had same number as some others. Swapped them, same sounds.
    • Wires/Cables – Connection from battery to starter was good
    • Key – I was pretty sure there was no chip in mine, but used a spare to be sure.
  • Analyzed Evidence
    • I had ruled out many components. Really all that seemed left was the starter. I thought through rule outs and couldn’t rule it out without changing it.
  • Probable cause – I was thinking starter now.
  • Verified – I am not mechanically inclined so I verified my direction, but as an amateur. I was solely using my troubleshooting skills here.
    • Internet – Found a few trustworthy sites describing starter issues. Symptoms matched, rule out steps matched and sites agreed. Still, it’s the internet…
    • Parts Store – Paid a visit and told them what I had done and what I was thinking. They agreed and added “starter problems almost always start intermittently, probably was better in winter because of how the metal moves”
  • Decided On Course Based on Evidence– I was going to sink the money on a starter. If it worked, it was likely it. If it didn’t I’d return/resell and call a “consultant” (tow truck to garage)

Researched the Solution Approach

I had to replace the starter. Could I? Or should I hire a consultant? Sometimes you can solve the issue. Sometimes a mentor or consultant alongside you makes a difference.

  • Level of effort – Could I do this myself? By all accounts, yes, if you can follow directions, wires and spin a ratchet.
  • Instruction – Looked for some quick training. I wanted to know some basics (What does a starter look like for instance… what tools do I need.. What precautions should I take, etc.)
  • Tools – Verified I had the right tools (Socket set really)

Chose a Path

I made my choice for a few reasons. I made sure I was ready and knew what I would do if I realized I was in over my head. I wasn’t going to get mad, start slashing with a hammer, cry, or make the problem worse. I’d consult to get the right help in.

  • Critical – I wanted to get this running, needed to for work. That helped make my call to give it a shot.
  • Relatively easy – The internet gave the general idea.
  • Had a backup plan  – Tow truck, AAA, Wife’s family members who are mechanically inclined
  • Go/No-Go – Couldn’t see any reason to not try. I Didn’t even have to lift truck and worry about it slipping off jack/jack stands and making my face a little flatter. We were a Go.

I Got Dirty Fixing the Problem

  • Got Dirty – Spent a lot of time under the truck finding exact location of starter.
  • Traced wire to starter – Did that by following the starter wire from battery I had read about and tested earlier.
  • Found bolts, found ratchet, made them meet
  • Brought it down – It was difficult to access.. I had to take fender off, an unexpected diversion with components I didn’t know how to work with (little plastic pop screws, broke a few before I figured it out)
  • Replaced It – Disconnected old one (pictured in this post), hooked up the new one and put it in the right spot.
  • Hooked up battery – (I had disconnected it before starting – made sure I was not working on live system… Always bad when you mess up in live)
  • Tested it a few times and ways – Mainly because I liked the sound of my truck starting and the look of my blackened, greasy hands turning the key 😉
  • SHIP IT! Problem solved.

Lessons For Next Time

I asked myself about what I could do differently next time –

  • Could have a few more tools for next time
  • Should have researched proper way to remove/replace fender fastener clips

So?

That’s really it. All of those steps are how we can solve any problem. When I ask that unrelated problem question or open ended “how would you deal with complaints of a slow SQL backed app?” I am looking for something logical, step based and calm. Something along the lines of these steps generally –

  1. Gather Initial Information
  2. Keep Thought Involved
  3. Rule In/Rule Out Causes Methodically
  4. Verify Your Understanding and Assumptions
  5. Propose Solution(s) Accordingly
  6. Carefully Test Proposed Solution  (if you can)
  7. Implement Fix
  8. Test and Verify Fix
  9. Learn for Next Time

And do all of that while remaining calm and keeping a picture on the big picture and the goals and make sure you don’t forget the main reason you are there.

[/et_pb_text][/et_pb_column_inner][/et_pb_row_inner][/et_pb_column][et_pb_column type=”1_3″][et_pb_sidebar admin_label=”Sidebar” orientation=”left” area=”sidebar-1″ background_layout=”light” remove_border=”on”] [/et_pb_sidebar][/et_pb_column][/et_pb_section]

Avatar
Article by Mike Walsh

Subscribe for Updates

Name

13 thoughts on “Can’t Troubleshoot? Don’t Apply!”

  1. Usually when the starter is the problem having someone turn the key in the ignition while you tap on the starter body with a hammer can validate that it is the source of the problem. The tapping with the hammer will usually work to free it up internally letting it turn over which proves the issue is inside of the starter itself. I always give the starter a final tap test before concluding it is the source of the problem.

    Reply
    • I should have mentioned that. I have had someone tap the starter before ( someone who knows cars) and it didn’t make a difference. I think it was beyond it’s last leg. Even noticed it sounded different when starting with the new starter.

      Reply
  2. Great post Mike. I don’t understand why people seem so reluctant to take this methodical, planned approach to troubleshoting, as opposed to the flail your arms, try everthing at once and shriek various curses method. Next time someone pulls that with me I’m pointing them here.

    Reply
    • Thanks for the comment, Josh.

      I am not sure why it isn’t always followed. I can say earlier in my career and even still sometimes with household issues/challenges, my first reaction may not always be the calm, logical, step by step approach to a problem. I think it takes work to get to that mindset. Some times and with some people that is a lot more work but it takes work either way.

      Reply
  3. Congrats on taking the initiative and fixing your truck. I am not that brave.

    Good read and reminder that there is an art of troubleshooting. Best piece advice “Don’t panic and stay calm”. 🙂

    Reply
    • Hey Cameron!

      I went through the pros and cons a few times before deciding on the “do it yourself” route. Seemed to be a fairly easy project and I could save myself the hassle of AAA tow to a garage, paying any difference and then paying the garage fee for the part, their markup and their time. I’ve been on a DIY kick lately. I find the more I’m willing to do myself, the more tools my wife lets me buy 😉

      Reply
  4. I’m always shocked when I run into people in IT who have almost no diagnostic skills. Even when I train them to go through a process that rules out certain possible conditions they still just don’t get it. I’ve often wondered if this sort if logic/cause/effect sense is a trait we are born with.

    I don’t know how one survives in IT without these sorts of skills, even if they have to fake them. 🙂 We can all get better at what we do by following your steps here.

    Reply
    • Thanks for the comment, Karen. I often run into people without those skills. I wish I could say it was rare, but it has to be at least monthly, if not weekly. It isn’t just technology, though – I’ve seen that skill lacking in other professions. I’ve even seen it spending time on ambulances, though those people never lasted (the practitioners, that is.)

      I go back and forth in my mind on if this is a nature or nurture trait. I look at myself and I can say I am a better diagnostician now than I was 12 years ago when I started in technology. I look around some household tasks and see that sometimes my first approach (depending on my interest in the task, perhaps?) sometimes is bordering on the “flail method”. So I think the traits/skills/”tools” can be learned but still you have to want to use them. So maybe it is a bit of both?

      Reply
      • Great post.

        Two useful tips regarding troubleshooting that I picked up the hard way over the years:

        1. When testing theories, only make one change at a time. Otherwise, if the issue is resolved you won’t know which change solved it.

        2. Keep a log of the steps you are taking. It is easy to forget the exact steps you took. If this happens, even though you solved the issue, you may not truly understand what fixed it.

        These may seem quite obvious but I’ve been surprised that many people don’t follow them.

        Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Share This