Collect performance and system information
This topic describes the following dbForge Monitor tabs:
To start monitoring SQL Server performance:
- In Object Explorer, right-click a connection.
- Select Show Monitor from the Monitor menu.
When accessing the dbForge Monitor tab, you are presented with a comprehensive set of 7 tabs that offer a wide range of metrics and statistics. These tabs serve as valuable tools for monitoring SQL performance, enabling the detection and resolution of performance issues and bottlenecks effectively.
Overview
The Overview tab consists of a collection of metrics for versatile monitoring of SQL Server performance in real time. The tab allows you to detect at a glance the volumes of CPU and Memory Utilization, monitor disc activity, detect the number of waiting tasks, deadlocks, etc. Moreover, you will see the informative Host Properties and SQL Server Properties blocks on the right side of the window.
Data IO
The Data IO tab contains statistics of the input and output operations, the total amount of data reads and writes, as well as read and write latency for each database file.
Databases
The Databases tab of dbForge Monitor provides details about databases on the monitored SQL Server instance. If any anomalies arise, you can promptly assess the performance information and take action if necessary. The tab critical metrics such as database state, its recovery model, database and data size, collation name, and more.
Wait Stats
With the Wait Stats tab, you will be able to see the list of waiting tasks encountered by execution threads because resources required for the request fulfillment were busy or not available. Here, you will find the information regarding wait type, the wait duration, the wait count, etc.
Top Queries
The Top Queries tab lists the most resource-intensive queries executed on the server. The tool also shows the query text and query profiling data that can help you to rewrite a query in the most productive way. It is a convenient graphical tool that enables you to see the efficiency of the queries at your fingertips. Each query in the batch being analyzed is displayed with the cost of each query as a percentage of the total batch cost.
Sessions
The Sessions tab shows the session statistics, including details such as the associated database and user, session status, wait time, CPU load, physical I/O, and the name of the active program. This tab offers a comprehensive overview of session-related information for effective monitoring and analysis.
Last Month Backups
Within the Last Month Backups tab, you can access valuable statistics regarding recently executed database backups. This includes essential information such as the database name, backup type, size, and physical location. This tab provides valuable information about when the database backups were made. If a database is absent from the list, it indicates either the absence of a backup for that specific database or that the backup was created a significant period ago.
Note
dbForge SQL Monitor does not log data. It only allows viewing the current state of databases and monitoring SQL Server performance in real-time.