Cary Millsap On Diagnosing Performance Problems
There's a good article currently featured on OTN about using Extended Trace to diagnose performance problems. Written by Cary Millsap and entitled "Diagnosing Performance Problems", it's worth taking a look at if you're about to start looking at Extended Trace and the 10046 event.