A little advertised session at PASS Friday was the real hidden gem of the conference.
Ken Henderson and Bart Duncan presented a new tool released today by PSS to analyze SQLDIAG captures. For those not familiar with SQLDiag, it captures traces, blocking, wait types ,etc. SQL Nexus allows you to import all this data into a database. It then provides Reporting Services reports on top of the tables to analyze the data out of SQLDiag. These reports are graphical, parameterized, and very meaningful. Think READ80Trace on steroids! In addition to SQLDiag stuff, it can report on CPU stats and other performance data coming out of DMVs inside SQL Server.
I am completely blown away by this tool. It is a must have for any DBA. You gotta
download it right now.