Tuesday, March 01, 2005

Performance: Diagnosing Performance Problems

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?"

No comments: