Advertisement
bytecoded

Top 5 Queries from Traces

Mar 23rd, 2019
344
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.23 KB | None | 0 0
  1. SELECT
  2.     [HashSQLMD5]            AS "HashSQLMD5",
  3.     SUM([cpu_time])         AS "Total CPU Used",
  4.     SUM(1)                  AS "Execution Count"
  5.  
  6. FROM TheLab..Traces200K
  7.  
  8. GROUP BY [HashSQLMD5]  
  9. ORDER BY [Total CPU Used] DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement