Extend the functionality of Microsoft SQL Server Management Studio with this add-in for analyzing and monitoring your MSSQL server databases. dbForge Monitor offers a variety of tools for tracking database read/write latencies, detecting slow queries, and more.
Tracking real-time metrics
Installation is straightforward. Once set up, you can access the tool from the SSMS interface by right-clicking on a database and selecting 'Monitor'. The plug-in organizes its interface into several tabs, each displaying different database metrics.
The main Overview tab displays core metrics like memory and CPU usage, disk activity, and other real-time database parameters. Other sections include a tab for analyzing slow-performing queries, another for showing tasks waiting on system resources, and several more covering similar database-related information.Built-in help and documentation
For the most part, the metrics shown by the add-in are intuitive, but if you run into any ambiguity, comprehensive help is available. This documentation can be accessed by right-clicking on the database and selecting 'Monitor', detailing how to use the add-in and what exactly each parameter means.A practical tool for administrators
dbForge Monitor is a well-built, useful SSMS plug-in for database application developers and administrators. It highlights relevant database information, helping you detect blockages in complex queries and resolve performance issues. Best of all, the add-in is completely free to use.