Finding the queries that use the most IO

• PAYAL.SEN

  Grasshopper

  Points: 14

  More actions

  April 3, 2012 at 8:28 pm

  #255879

  Comments posted to this topic are about the item Finding the queries that use the most IO

• Carlo Romagnano

  SSC-Insane

  Points: 22682

  More actions

  April 4, 2012 at 1:10 am

  #1468656

  I tried on my production server:

  I got interesting results

  ordering by [Total IO] instead of [Average IO].

  Thanks!

• gil 17845

  SSC Enthusiast

  Points: 132

  More actions

  April 4, 2012 at 5:09 am

  #1468740

  Thanks -- very handy.

  Actually, here's a free tool I use for troubleshooting a wide range of query-related problems (by I/O, by CPU, by User, by multiple dimensions... whatever).

  It's called Qure Analyzer. The tool takes a trace file (or trace table) as input, and provides a wealth of analytics about the query activity. Free and full-functionality. Here's the download link: SQL Server trace file analyzer.

• dbajunior

  SSCrazy

  Points: 2307

  More actions

  April 4, 2012 at 8:08 am

  #1468884

  Is there any way to get the name of the SQL module where the query resides?

• jswong05

  Hall of Fame

  Points: 3553

  More actions

  April 9, 2012 at 10:43 am

  #1470752

  You would want to query the actual physical IO.

  Jason
  http://dbace.us
  😛