code_junkie

How Can I Log and Find the Most Expensive Queries?

Nov 12th, 2011
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. RPC:Completed
  2. SP:Completed
  3. SP:StmtCompleted
  4. SQL:BatchCompleted
  5. SQL:StmtCompleted
  6.  
  7. SELECT * INTO TraceTable
  8. FROM ::fn_trace_gettable('C:location of your trace output.trc', default)
  9.  
  10. SELECT COUNT(*) AS TotalExecutions,
  11. EventClass, CAST(TextData as nvarchar(2000))
  12. ,SUM(Duration) AS DurationTotal
  13. ,SUM(CPU) AS CPUTotal
  14. ,SUM(Reads) AS ReadsTotal
  15. ,SUM(Writes) AS WritesTotal
  16. FROM TraceTable
  17. GROUP BY EventClass, CAST(TextData as nvarchar(2000))
  18. ORDER BY ReadsTotal DESC
Add Comment
Please, Sign In to add comment