Trace Analyzer is a simple tool designed to display SQL trace in a Graphical format and hence provide a richer more interactive way of display the data. The code can be downloaded here
It currently enables the user to
- Parse trace files.
- Profile the data via a bar of the right had side of the scroll bar.
- Supports dynamic filtering and sorting of the data.
- Highlight the 5 worst performing pieces of SQL (elpased, cpu, physical etc)
- SQL Explain Plans
- Bind parameters from 10046 trace files
Future features will include
- Dump sql to flat files
- Generate load files for swingbench