SQL Live Monitor will provide realtime performance data on the target SQL Server instance. Realtime performance data on the target SQL Server instance.

No installation required, data displayed in realtime, and can also be logged to CSV for offline analysis. Will also capture SQL data for processing uing PAL. This tool is designed to provide realtime performance data on SQL Server, as well as data capture for offline analysis.
SQL Live Monitor Features:
* Realtime SQL and System performance data
* Colour coded alerts
* Capture data logging to CSV - sample interval configurable
* PAL Perfmon counter logged to .blg or .csv for offline analysis using PAL - sample interval configurable
* Detailed view of certain SQL Areas via DMVs
* List Top 20 Queries by CPU, IO and Execution Count
* View SQL Waits by category
* View SQL Scheduler and CPU worker threads
* Monitor Kernel Pools and System PTEs
* Supports SQL 2000,SQL 2005, SQL 2008
* Captures data from local and remote servers
* Captures data from default and named instances (stand alone & clustered)
* Supports both SQL and Windows Authetication
* Supports x86 and x64
* No installation required
* Application small in size with minimal overhead when running
* Run multiple instances on same PC

The license of this software is Free, you can free download and free use this server monitoring software.