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: 306
I’m trying to make TraceTune (and eventually ClearTrace) work the way I do. My typical query tuning session goes like this:
- Run a trace and upload to TraceTune/ClearTrace
- Tune the slowest queries
- 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.
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