DEVOPSdigest

Redgate’s database monitoring tool, SQL Monitor, now offers support for SQL Server on Linux.

SQL Monitor collects Windows machine metrics using WMI queries, for example, and is agentless, which reduces the load on the servers being monitored. This has the added advantage that it enables a web-based dashboard to be used, enabling access from anywhere and across a wide range of devices.

The metrics themselves, however, need to be exhaustive in order to provide the broadest, and deepest, picture of the host machine’s health, its performance, and its configuration. To achieve this, SQL Monitor now collects Linux metrics across a variety of measures like CPU, memory, network, and disk activity, along with the most resource-intensive processes, and the operating system properties in order to provide the most useful information and alerts.

Those metrics as well as the processes, properties, and alerts are displayed alongside those of SQL Server on Windows on-premises, or in Azure, AWS, or GCP. This lets users get the most out of SQL Monitor’s intuitive interface, which enables entire estates to be managed from a single pane of glass, whether servers are hosted locally or in the cloud.

Max Drobot, Product Manager of SQL Monitor at Redgate, comments: “The SQL Server on Linux support which has now been launched gives organizations the opportunity to experience first-hand how they can now monitor their databases, whether on Windows or Linux, using one tool with a single view of their database estate. The teams behind the development have reached another major milestone for SQL Monitor.”

The work has also opened the door to expanding the use of SQL Monitor beyond platforms to open source database engines that are commonly hosted on Linux machines. For a year now, another development team at Redgate has been working on adding support for PostgreSQL to SQL Monitor. The Linux project has laid the foundations for that support to be even more comprehensive than originally planned.