Last updated: 2018-12-02

SQL Server Monitoring Agent

Monitor OnPremise SQL Server instances and cloud based Azure SQL Databases with Nodinite SQL Server 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. This is together with the BizTalk Monitoring Agent one of our most appreciated and most commonly used agents.

Documentation support is provided by the Repository Model model.

Release Notes

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

About

This topic links to documentation resources about how to use the monitoring agent for SQL Server (including Azure SQL Databases).

The agent provides a way to monitor key features in SQL Server. For example; It is crucial to know when backups are not taken/failing, jobs are not running and your own custom TSQL statements are not returning the expected result, due to the fact that this might cause business critical errors. With this agent you can configure Nodinite to execute and monitor all imaginable SQL statements and their result (designed to be extensible).

The current state of the Resources are available in Monitor Views and alerts can be distributed (pushed) to end users (Mail, Ticket handling systems, etc.).
Alert Metrics can be displayed either in the dashboard or using custom Reports using Power BI or any other tool that you prefer since data comes from our REST based Web API.

  • SQL Server and Azure SQL 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
  • Any number of SQL Instances 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
  • Report capabilities

Monitor Capabilities

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

  • SQL Jobs - Monitor how SQL Agent jobs perform
  • SQL Backups - Monitor your backups, displays the time of the last backup taken (if any).
  • SQL SSIS - Monitor SSIS package execution
  • Size Checks - Monitor file usage (data and log separately)
  • SQL Instance - Provides general information about the SQL Instance
  • SQL Statements - Monitor the state of your business data running custom TSQL statements (including stored procedures)
  • Azure Size Checks - Monitor file/space usage
  • Azure SQL Statements - Monitor the state of your business data running custom TSQL statements

Actions

Fix your SQL related problems with ease from a distance without the MMC (SQL Server) or the Azure portal (SQL Databases).

Using the Web Client for Nodinite, Actions can be sent to the Monitoring Agent for SQL Server requesting operations to be performed on the monitored resources. With the existing privilege model you can allow certain users to perform operation on selected resources.

List of Actions on the Resources of SQL Categories that can be executed from using this agent:

  • SQL Jobs
    • View 'SQL job history' for individual jobs
    • Edit time thresholds with ease
    • Start job
    • Enable job
    • Disable job
  • SQL Backups
  • SQL SSIS
    • View 'SQL SSIS run history' for individual packages.
  • Size Checks
    • Edit size thresholds with ease, Data and Log separately
  • SQL Instance
    • View SQL Log (current)
  • SQL Statements
    • Edit SQL Statements with ease. Support for Stored Procedures and AdHoc TSQL.
  • Azure Size Checks
    • Edit size thresholds with ease
  • Azure SQL Statements
    • Edit SQL Statements with ease. Support for Stored Procedures and AdHoc TSQL.

Supported Versions

  • SQL Express (not SQL Jobs due to missing SQL Agent)
  • SQL Server
  • SQL Database (Azure)

All editions, Developer, Standard, Enterprise are supported.

Default and named instances are supported.

All SQL Server versions beginning with 2008 R2 and later are supported, older versions might work with limited set of features. Our aim is always to support the latest versions and standards, often including CTP releases.

  • SQL Server 2016 is supported

Release Log

For information about the latest release, see Release Log


Next Step

Install SQL Monitoring Agent
Configuration of the agent

Prerequisites for SQL Monitoring Agent