The good folks just south of me in Kansas City at ClearData Consulting have created a new (beta) utility called ClearTrace.
This tool imports SQL Server 2000 and 2005 trace (and profiler)
files into SQL Server and displays summary performance information. It
is designed to provide the same performance summary as Read80Trace but
in a graphical environment and for SQL Server 2005. Remember this is
beta but it pretty handy!
Another tool that I just saw but haven't had a chance to try yet is SQL DMVStats by Tom Davidson.
DMVstats 1.0 is an application that can collect, analyze and report
on SQL Server 2005 DMV performance data. (Microsoft SQL Server 2005
provides Dynamic Management Views (DMVs) to expose valuable information
that you can use for performance analysis.) DMVstats does not support Microsoft SQL Server 2000 and earlier versions.
Main Components The three main components of DMVstats are:
- DMV data collection
- DMV data warehouse repository
- Analysis and reporting.
Data collection is managed by SQL Agent jobs. The DMVstats data
warehouse is called DMVstatsDB. Analysis and reporting is provided by
means of Reporting Services reports.
Enjoy!