May 16, 2012 at 5:53 pm
Is there a good/convenient tool (free/paid) that can take in a whole bunch of trace files and summarize them and show reports in a user friendly format (preferably good UI)?
An important criteria is that it should not have specific restrictions (e.g. The 1st trc file should always have a "Start Trace" etc).
The scenario is that we get trace files from Prod that our DBAs manage, and if I want to look at what happened between 8:30 and 9:00 I'll have 10 contiguous trc files (MyDB_trace_3567 ... 3577 etc). and I would like to be able to use the tool to load up those 10 files (which neither have a trace start/stop, and just summarize them, ideally graphically, ideally top calls by number of executions, duration, cpu etc etc. and ideally be able to drill down into any given graph/report.
The only event that is captured in our trc files is "RPC Completed" having duration > threshold.
I know there are some tools out there that do this kind of thing, but would like community feedback on which ones are the best. And I haven't checked out any of these.
Thanks,
Rajesh
May 16, 2012 at 7:51 pm
ClearTrace[/url] by Bill Graziano from ScaleSQL Consulting will suck in profile traces and give you really good summary.
SQLNexus by Jack Li from Microsoft Support goes a little bit deeper. It can process profile traces, but will also create reports for WAITSTATS and blocking. be sure to look at the Perf Stats scripts, they make data collection a piece of cake.
Both have their strengths. Both are free.
Have a crack at them, they should be in every DBAs toolkit
Peet
May 29, 2012 at 5:20 pm
Thank you! I will check those out.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply