dbForge Monitor offers support for expanding database estates. It allows you to easily manage and monitor multiple SQL Server instances from a single interface. You can effortlessly switch between different servers and databases, ensuring you stay in sync with your expanding database environment.
Discover a range of features that enable users to achieve these goals:
Data input and output: On the IO Data tab of the tool, you can get insights into statistics of the read and write operations for each database file, input and output operations, the total amount of data reads and writes, as well as read and 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 check SQL Server performance information. There are a number of highly useful metrics displayed, including database state, recovery model, the total size of a database and data, collation name, etc.
Wait statistics: On the Wait Stats tab, you can locate the resources that slow down the server, which is the quickest and easiest way to identify if there are any bottlenecks. The wait statistics information, such as the wait type, the wait duration, and the wait count, help in monitoring performance issues in SQL Server.
Top queries: dbForge Monitor includes a SQL query performance analyzer that allows you to detect and optimize the most resource-intensive 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 can be demanding in terms of resources, particularly when dealing with larger databases. It is important to trace the backup process effectively. dbForge Monitor provides a quick overview of backup events on your server and displays the key statistics.
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.