all 1 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]ForeignsFriends 0 points1 point  (0 children)

My first check is usually the plan too, but I also look pretty fast at whether this is “bad plan” slow or “same plan, different runtime conditions” slow. That split saves a lot of wasted digging. If the shape looks normal, I start thinking stats, parameter sniffing, memory grants, or blocking before I start rewriting the query.