Friday, August 17, 2012

My Perspective: The Top 5 Most Common SQL Server Performance Problems

This post has been moved!
Please visit my new blog here: 


  1. The tongue-in-cheek response:

    1) End users writing poor queries
    2) Power users writing poor queries
    3) Junior developers writing poor queries
    4) Senior developers writing poor queries
    5) Software architects writing poor queries.

    1. You know, I started with that, but I was having trouble filling a page ;)

  2. Another quick note on client timeouts.

    The knee jerk reaction is very frequently "can we increase the timeout". The answer is no. That query is performing poorly. It is a big ugly troll eating up time, and the answer is not to feed the troll more time. You want to take that troll to the gym, and get him running faster by tuning him instead!

  3. You bring up an excellent point about the regular system process histories, like those in the SQL Agent. I've also seen that happen with job history and job step history in MSDB where that database grows to enormous size too.

    Great post, btw!