posts - 219, comments - 411, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

TraceTune: Larger Files and History

I updated TraceTune over the weekend.  I increased the trace file upload size to 20MB.  We’ve processed over half a million rows of trace data so far and I’m confident this won’t kill the server.

I added average CPU and average disk reads to the screen that lists the SQL statements in a trace file.

List of SQL statements in a trace

I only added these two.  I’m pretty sure average writes isn’t that import.  I’m still thinking about average duration.  I’m trying to balance showing you what you need with a clean, simple interface.  Plus I have a way to see the averages that I describe further down.

TraceTune now keeps the last 10 files that you’ve uploaded and will give you some basic details about each file.

List of SQL statements in a trace

I think the last change I made is the most interesting. For each SQL statement, I show the history of that statement.

List of SQL statements in a trace

You’ll see each trace file where this statement was found.  It will list the averages for CPU, reads, writes and duration.  This will quickly show you if you’re improving the performance of that query.  In my screen shot above you can that even though the execution counts are very different the averages are consistent.

If you want to see what queries are consuming the most resources on your server give TraceTune a try.

Print | posted on Monday, January 24, 2011 7:59 AM | Filed Under [ Utilities ]

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET