Enter comments on queries in TraceTune

Posted by Bill Graziano on SQL Team See other posts from SQL Team or by Bill Graziano
Published on Mon, 07 Feb 2011 13:48:26 GMT Indexed on 2011/02/07 15:29 UTC
Read the original article Hit count: 312

Filed under:

I’m trying to make TraceTune (and eventually ClearTrace) work the way I do.  My typical query tuning session goes like this:

  1. Run a trace and upload to TraceTune/ClearTrace
  2. Tune the slowest queries
  3. Goto 1

I might do this two or three times in one day and then not come back to it again for weeks or even months.  This is especially true for those clients that I only visit a few times per month.  In many cases I’ll look at a query, decide I can’t do much with it and move on.  I needed a way to capture that information.

TraceTune now lets you enter a comment for a query.  It can be as simple or as complex as you like.  The comment will be shown inline with the execution history of that query.

image

This should let you walk back through your history with a query and decide whether you should spend more time tuning it.

© SQL Team or respective owner