SQL Server Monitoring Tool

Analytical SQL Server Monitoring Dashboard

The Overview tab of the tool allows you to view from different perspectives what actually happens at your SQL Server. A rich collection of metrics for versatile real-time monitoring of SQL Server performance embraces:

• CPU Utilization
• Memory Utilization
• Disc Activity
• Read and Write Latencies
• IO latency

... and much more!

Data Input/Output

On the IO data tab of the dbForge SQL performance analysis tool, you can get insights into 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

Summary Statistics for all Databases

The Databases tab gives a general view of all your SQL Server databases. In case anything looks disturbing, you can swiftly check SQL Server performance information. There are a number of highly useful metrics displayed including but not limited to:

• Database state
• Recovery model
• Total size of a database
• Data size
• Collation name

Wait Statistics

On the Wait Stats tab, you can rapidly locate the resources that slow down the server. The Wait Statistics information, such as the wait type, the wait duration, and the wait count, significantly help in monitoring performance issues in SQL Server. Often, it's the quickest and easiest way to identify your bottleneck.

Top Queries

dbForge Monitor includes a SQL query performance analyzer that allows you to detect and optimize the most expensive queries that overload the system. Apart from the list of poorly performing queries, the tool displays the query text and query profiling information that can help you rewrite a query in the most productive way.

Sessions

The Sessions tab allows tracking the number of active sessions on each of the databases on your server. It enables you to determine the users currently logged in to your databases and the applications they are running. By monitoring the number of SQL Server sessions, you can track how loaded your databases are and understand which users take more system resources.

Backups

SQL Server backup operations are quite heavy, especially when the database is relatively large. Therefore it is important to trace the backup process. dbForge Monitor provides a quick overview of backup events on your server and displays the key statistics on backups.