What is SQL Monitor
Published 14 February 2023
SQL Monitor is a SQL Server and PostgreSQL monitoring and alerting tool, designed to help DBA teams proactively manage any number of instances, whether they are hosted on bare-metal servers, on Virtual Machines, or in the cloud.
A Base Monitor service continuously monitors the availability, health and performance of monitored servers, instances and databases, collecting and assessing a range of machine, instance and database-level metrics, and associated alert data. This is stored it in a SQL Server database, and then presented in a single graphical web interface for review and analysis. SQL Monitor doesn't require installation of an agent on any of the monitored machines. Instead, SQL Monitor uses only industry standards, WMI, TDS and SSH, to collect monitoring data from remote computers.
SQL Monitor watches the whole estate and raises alerts that warn the DBA of actual or impending problems. It speeds up diagnosis of alerts by summarizing the symptoms of the problem, alongside the SQL text, execution plans and performance statistics for server and user processes running around that time.
By collecting and analyzing metrics over time, SQL Monitor makes it easier to spot and fix concerns before they become a problem that impacts the running of the database. It reveals disconcerting trends, such as rapid database growth and uses baselines to compare the current server behavior to historical behavior over similar periods.
By almost eliminating the need for routine manual checks on each database service, it enables better quality of service, without the need for ad hoc scripting.