This is one of the best tools I have seen in awhile.
Be sure to run sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Ole Automation Procedures', 1; GO RECONFIGURE; GO
to access certain features. The biography and live monitoring features are a must see.
Project SQL SPY 5.2 is out! This version of SQL SPY fully supports SQL Server 2005 and has many new features exclusively for SQL 2005.
SQL SPY was designed as a tool to display, monitor and report on valuable SQL Server information.