Strictly dedicated to monitoring Microsoft SQL Serve.
Edit by : SQL SPY 6 Live Monitoring Feature List:

1. Connection Bubble Report: Displays connection information in a graphical bubble display of Waiting, Executing, Blocked and Wait-time connections.

2. Activity Monitors: This features is actually two features in one. The Resource Distribution Bars, displays how the MS SQL Servers IO, CPU and Memory are distributed, and the Activity Graph which displays the overall activity of the MS SQL Server using ISpySQLs internal Algorithm.

3. User Connections: Displays a very detailed Grid style report in near real-time of all incoming connections (Includes the ability to terminate a connection, filtering, and you can double click on a connection to produce an HTML report with complete resource analysis for said connection).

4. T-SQL SPY: Shows the incoming SQL code of each connection (Includes statement tracking) This feature is designed for MS SQL Server 20052008. Now with the ability to record and report on T-SQL Statistics. How to use the new features: See http://www.ispysql.com/forum/viewtopic.PHP?f=11&t=115

5. Database Activity: Graphically or textually displays how incoming connections are distributed across databases.

6. CPU Monitor: Displays a graph to monitor the amount of CPU usage that the Microsoft SQL Server you are monitoring is using.

7. SQL Services Monitor: Displays the statuses of all Microsoft SQL Services. you can free download SQL SPY 6.0 now.