Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- RPC:Completed
- SP:Completed
- SP:StmtCompleted
- SQL:BatchCompleted
- SQL:StmtCompleted
- SELECT * INTO TraceTable
- FROM ::fn_trace_gettable('C:location of your trace output.trc', default)
- SELECT COUNT(*) AS TotalExecutions,
- EventClass, CAST(TextData as nvarchar(2000))
- ,SUM(Duration) AS DurationTotal
- ,SUM(CPU) AS CPUTotal
- ,SUM(Reads) AS ReadsTotal
- ,SUM(Writes) AS WritesTotal
- FROM TraceTable
- GROUP BY EventClass, CAST(TextData as nvarchar(2000))
- ORDER BY ReadsTotal DESC
Add Comment
Please, Sign In to add comment