Look around and find any SQL Server monitoring tool. Now compare them to SQL SPY. What you will find is that you are going to pay hundreds, if not thousands of dollars for them. Since 1999 I have dedicated all my free time to developing an alternative to those high priced applications. Will those companies actually listen to you and add the features or functionality that you really want? SQL SPY 6 can change frequently, we pride ourselves on quick bug fixes, so please check back often.

 
SPY SPY 6.5 Note: If you are upgrading from a previous version of SQL SPY, right click on each SQL Server then click "Refresh Connection Information". This is the ONLY way to see the new features.

FYI: SQL SPY 6 can and will change frequently. When a bug is found, we jump right on it.

Version 6.5 release notes: Click Here!

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 Server's I\O, CPU and Memory are distributed, and the "Activity Graph" which displays the overall activity of the MS SQL Server using ISpySQL's 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. Database Activity: Graphically or textually displays how incoming connections are distributed across databases.
5. CPU Monitor: Displays a graph to monitor the amount of CPU usage that the Microsoft SQL Server you are monitoring is using.
6. SQL Services Monitor: Displays the statuses of all Microsoft SQL Services.
7. DML Monitor: Monitors DML Statements found in all the executing TSQL Statements. One graph for each DML Statement type, Selects, Inserts, Updates and Deletes, as well as a grid display of DML Statements broken down by Database, Application, Host and Login.
8. Inserts, Updates, and Deletes: Displays any Insert, Update, and\or Delete statements found during the scan cycle.
9. Live Stored Procedures: Displays any Stored Procedures being executed during the scan cycle.
10. Live Tables: Displays any tables inside statements found during the scan cycle.
11. Database Read\Write Information: Displays Read\Write Activity by Database.
12. Index Activity by Database: Displays Index Activity by Database.
13. Statistics Information: Displays Statistical Information.
14. Database Read\Write Information: Displays Read\Write Activity by Database.
15. Trace Events: Displays Trace Event Information.
16. Page Life Expectancy Graph:The amount of time a page stays in the buffer pool.
17. Wait Statistics: Displays the Wait Statistics by Type.
    
    
    

Not all features refresh rates can be adjusted individually

Note: This image is from SQL SPY 6.5



Remember to checkout the SQL SPY forum for the latest release notes.

Upgrading any version of SQL SPY to the latest?
You must drop and re-register each SQL Server you already have in SQL SPY. We are sorry but this is by design.

SQL SPY! Download Now

Requires Free Registration

If you are having issues with Windows 7 and SQL SPY permissions, use this. Download and run after you install SQL SPY.
Download: SQL SPY 6x Mitigation Patch