Performance: Diagnosing Performance Problems: "Diagnosing Performance Problems
By Cary Millsap
Use extended SQL trace data to see what's taking so long.
Suppose that one day you are driving to work and end up arriving late for an important meeting. You aren't able to present your revolutionary idea, so your clients aren't going to use it. You're frustrated by your tardiness and vow to never make the same mistake again. So how do you diagnose the cause in order to avoid a replay? How about this checklist?"