What is Redgate Monitor
Published 28 March 2024
Redgate Monitor is a SQL Server and PostgreRedgate 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. Redgate Monitor doesn't require installation of an agent on any of the monitored machines. Instead, Redgate Monitor uses only industry standards, WMI, TDS and SSH, to collect monitoring data from remote computers.
Redgate 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, Redgate 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.