If you are tracing the events ‘SP:StmtStaring, SP:StmtCompleted’, SQL Profiler records a detailed statistics for you. Trace Analyzer can put all these pieces of a puzzle together. Click on ‘Debug execution’ button to get a source code of a stored procedure with an attached performance data.