Database Monitoring Agent

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.

This agent has been developed with demands set from a company specializing in providing services and 24/7 support for Microsoft SQL Server. This ensures capabilities, performance and overall quality. Together with the BizTalk Monitoring Agent this is one of our most appreciated and most commonly used agents.

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

The agent provides a way to monitor key features in various databases like SQL Server, Azure Databases and PostgreSQL. For example; It is crucial to know when backups are not taken/failing, jobs and SSIS packages are not running. If the built-in monitoring is not enough for your needs you can add your own TSQL statements. With this agent you can configure Nodinite to execute and monitor all imaginable SQL statements and their result.

The current state of the resulting Resources are available in applicable Monitor Views. Alerts can get distributed (pushed) to end-users (Mail, Ticket handling systems, etc.).

Alert metrics can be displayed either in the dashboard or using custom Reports like Power BI or any other tool that you prefer since all Nodinite data is available using 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 which removes the need of the MMC/remote desktop connections
• Large number of databases can be monitored from a single agent
• Multiple agents can be deployed on multiple servers
• Servers can be local or in the cloud, and even off-site (partner/customer location)
• Low overhead with least privileges policy

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

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:

• SQL Backups

  • Edit thresholds

• SQL Blocking

  • Details

• SQL SSIS

  • View 'SQL SSIS run history' for individual packages/projects.

• SQL Size Checks

  • Edit size thresholds, Data and Log are set separately

• SQL Instance

  • View SQL Log (current)
  • Details

• SQL Jobs

  • View 'SQL job history' for individual jobs
  • Edit thresholds
  • Start job
  • Start job at step
  • Stop job
  • Enable job
  • Disable job

• SQL Statements

  • Edit SQL Statements. Support for Stored Procedures and AdHoc TSQL.

• Azure Database Size Checks

  • Edit size thresholds

• Azure SQL Statements

  • Edit SQL Statements. Support for Stored Procedures and AdHoc TSQL.

• PostgreSQL SQL Statements

  • Edit SQL Statements. Support for AdHoc SQL.

Supported 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

Related

Prerequisites for Database Monitoring Agent