Trace Analyzer

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