If you are looking for a tool to monitor performance information for SQL Server in real-time, there is a free tool available on Codeplex called SQL Live Monitor that has a GUI interface and does not require installation. From the site, these are the features that it supports:
- 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 PTE's
- 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
There is some light documentation for a Quick Start and how to monitor clusters, as well as export data to PAL (Performance Analysis of Logs), which I will cover in a separate post.
No comments:
Post a Comment