dbForge Monitor is a FREE add-in for Microsoft SQL Server Management Studio that allows you to track and analyse SQL server performance. The tool includes a variety tools for SQL Server diagnostics, including a bunch of SQL performance metrics allowing to see the comprehensive and clear picture of all processes taking place on the server, detect most expensive queries, waiting tasks, and performance bottlenecks. With dbForge Monitor, you will save hours of time spent on SQL Server performance analysis!
Key Features:
* Dashboard
The Overview tab of the tool allows you to see what actually happens at your SQL Server from various angles. A rich collection of metrics for versatile monitoring of SQL Server performance includes:
- CPU Utilization
- Memory Utlization
- Disc Activity
- Read and Write Latencies
- IO latency
*Data Input/Output
With the IO data tab of the tool, you can easily view statistics of the read and write operations for each database file. In particular, you can track:
-Total amount of data reads and writes
-Count of input/output operations
-Read/write latency
*Wait Statistics
The Wait Stats tab, you can identify the resources that slow down the server. It shows the list of waiting tasks encountered by execution threads because resources required for the request fulfillment were busy or not available. more
Comments