If you haven’t purchased the book “SQL Server 2005 Practical Troubleshooting: The Database Engine“, we would highly recommend it. One of the utilities that was provided on the CD with this tool was SQL Nexus. This utility was developed by Ken Henderson and Bart Duncan and can be used to collect performance information pertaining to SQL Server and generate and visualize it via a set of SSRS (Reporting Services) based reports for further analysis. It is based off SQLDiag as the main back-end data collection tool. The kind of diagnostic data that you wish to collect is also configurable through an XML file.
We would encourage you to download this wonderful utility and become familiar with it – this could be a real lifesaver in production environments.