TraceTune: Improved Comment View

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

Filed under:

I wanted an easier way to identify queries I’d already looked at so I could skip them.  I’ve been entering comments for each query as I review it.  These comments typically fall into three categories: a change I made, no easy fix available or something needs to be changed on the client. 

TraceTune now highlights any statement with a comment in bold.  If you hover over the statement you’ll see the most recent comment for that statement.

TraceTune comment pop up

This gives me a quick way to see what’s new and identify those queries that still need work.  This is especially helpful when I come back to a server after weeks or months away.  These comments help jar my memory and remind me what I’ve worked on.

I made the font slightly smaller in some of the tables.  It’s still readable but I’m able to get more of a SQL statement on the screen.  I also got to re-experience the pain of Internet Explorer, Chrome and FireFox all displaying text (and pop-up text) slightly different.

Seeing the comments on a trace has been a big help to me.  I often do a round of tuning and then don’t come back to a server until months later.  Having the comments available helps me get back up to speed quickly.

© SQL Team or respective owner