March 17, 2009 at 7:19 pm
I have a number of traces from different servers all running the same application. I'd like to be able to rollup all the queries to determine which queries are run frequently and which ones tend to take the longest to run. However none of the queries are parameterized so it's hard to do any grouping. Read80trace reduces the queries into a common query format, does anyone have an idea how they do that?
Thanks.
March 17, 2009 at 11:24 pm
You can try using SQLNexus to check out the logs and such. It is a newer version that helps to read trace data collected.
As for Read80Trace, what you can do is .. import all your logs into SQL Tables...
And then run it through search and replace to similar queries to replace the values with generic variables.. at least thats how I have done it for cursor based systems...
Link: http://www.codeplex.com/sqlnexus
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 18, 2009 at 7:16 am
The chapter on Profiler and Tracing in Inside SQL Server 2005: Query Tuning and Optimization there are a couple of scripts written by Itzik Ben-Gan to do this. You can find them on this page.
You can also check out the RML Utilities which include a ReadTrace for 2005. Here's a blog post about it.
Also Bill Graziano created a utility called ClearTrace that he mentions here.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 18, 2009 at 7:38 pm
Many thanks Jack, Itzik's method is exactly what I am looking for.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply