New Born DBA (4/29/2014)
I have no skill on performance tuning whatsoever, however I tried following this link https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/ and ran a trace.
That article points out that just looking for the highest duration query is a waste of time, and it suggests aggregating by procedure name to get the overall highest impact queries.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability