- 5 minutes to read

Release Notes

Database Monitoring Agent

Gain full control and visibility over your SQL Server, Azure SQL Database, and PostgreSQL environments with the Nodinite Database Monitoring Agent. This page explains how you can proactively detect issues, automate alerts, and resolve problems efficiently—empowering both integration experts and decision-makers.

✅ Monitor SQL Server, Azure SQL Database, and PostgreSQL from a single agent
✅ Instantly detect failed backups, jobs, and performance issues
✅ Automate alerts and remote actions for rapid resolution
✅ Visualize metrics in dashboards and custom reports
✅ Integrate with your existing tools using the REST-based Web API

Info

Plug and Play! No changes to the existing solutions

Monitor on-premise SQL Server instances and cloud based Azure SQL Databases as well as PostgreSQL databases with the Nodinite Database Monitoring Agent.

graph LR subgraph "Nodinite" roNI(fal:fa-code-commit Database Monitoring agent) --- roMonitor[fal:fa-monitor-waveform Monitoring] end subgraph "SQL Server" roDB1(fal:fa-database SQL Instances) end subgraph "Azure" roDB2(fal:fa-database Azure Databases) end subgraph "PostgreSQL" roDB3(fal:fa-database PostgreSQL Instances) roMonitor ---roDB1 roMonitor ---roDB2 roMonitor ---roDB3 end

Architecture overview: The Nodinite Database Monitoring Agent connects to SQL Server, Azure, and PostgreSQL for unified monitoring.

This agent was developed in collaboration with a company specializing in 24/7 Microsoft SQL Server support, ensuring robust capabilities, high performance, and reliability. Alongside the BizTalk Monitoring Agent, it is one of our most popular and trusted solutions.

*Example: Failing SQL resources as visualized in :Nodinite: Monitor Views.*

Use the Nodinite Repository Model to Document all your databases and related information.

The agent enables you to monitor key features in SQL Server, Azure Databases, and PostgreSQL. For example, you can track failed or missing backups, jobs, and SSIS packages. If built-in monitoring is not enough, you can add your own TSQL statements. With this agent, Nodinite can execute and monitor any SQL statement and its result.

The current state of Resources is available in Monitor Views. Alerts can be distributed to end-users (Mail, Ticket handling systems, etc.).

Alert metrics are available in dashboards or custom Reports such as Power BI, or any tool that can consume data from the REST-based Web API.

Features

  • SQL Server, Azure SQL Databases, and PostgreSQL databases are supported from the same installed agent
  • Remote Actions are available on some resources, eliminating the need for MMC/remote desktop connections
  • Monitor a large number of databases from a single agent
  • Deploy multiple agents on multiple servers
  • Monitor servers locally, in the cloud, or off-site (partner/customer location)
  • Low overhead with least privileges policy

The Resources are grouped by Categories. The following SQL Categories exist:

SQL Server

  • SQL Backups - Monitor your backups, also provides the time of the last backup taken (if any).
  • SQL Blocking - Monitor blocking processes.
  • SQL Instance - Provides general information, and the log about the monitored SQL Instances.
  • SQL Jobs - Monitor, control and view history on SQL Agent jobs perform.
  • SQL Size Checks - Monitor space usage (data and log separately).
  • SQL SSIS - Monitor SSIS package execution (Master projects and shared projects).
  • SQL Statements - Monitor the state of your business data running custom TSQL statements (including stored procedures).
    • Execute Script - Execute a pre-defined script. Easy access to a script collection, simply execute and review the result.

Azure Databases

  • Azure Size Checks - Monitor space usage
  • Azure SQL Statements - Monitor the state of your business data running custom TSQL statements
    • Execute Script - Execute a pre-defined script. Easy access to a script collection, simply execute and review the result

PostgreSQL

  • PostgreSQL SQL Statements- Monitor the state of your business data running custom SQL statements
    • Execute Script - Execute a pre-defined script. Easy access to a script collection, simply execute and review the result

Actions

You can find information and fix many of your SQL related problems with ease from a distance without the MMC (SSMS) or the Azure portal for (Azure SQL Databases).

Using the self-service enabled Web Client for Nodinite, Remote Actions can be sent by the Database Monitoring Agent requesting operations to be performed on monitored Resources. With the existing privilege model you can allow certain users to perform operation on hand picked resources.

Below you will find a list of featured Remote Actions per SQL Category:

Supported Versions

Product Version history Supported versions Comment
SQL Server SQL Server versioning 2008 R2, 2012, 2014, 2016, 2017, 2019 All editions, Preview, Developer, Standard, Enterprise are supported.
Default and named instances are supported.
SQL Express SQL Server Express versioning 2008 R2, 2012, 2014, 2016, 2017 Not all monitoring features are available due to limitations within SQL Server Express
SQL Database (Azure) Not all monitoring features are available due to limitations within SQL databases within Azure
Postgresql Postgresql Versioning v9 and later (earlier versions may work, please contact our support if you need compatibility with older versions)

Our aim is always to support the latest versions and standards, often including CTP releases as we tend to develop on the very latest technologies.

Release Notes

For more information about the release history and latest version, see Release Notes.

Next Step

Install Database Monitoring Agent
Configuration of the agent

Prerequisites for Database Monitoring Agent