Managing Monitoring of SQL Backups

Info

This monitoring feature helps you get alerted when your SQL Databases backups in SQL Server are outdated and/or the database is unavailable.

The Database Monitoring Agent monitors the backups taken for all databases on all configured SQL Database Instances. Each monitored database is represented in Nodinite as 1 Resource. Each SQL Backup returns its evaluated state which therefore can be monitored from the use of Monitor Views and external alerts can be pushed using any of the installed : Alarm Plugins.

Size checks Monitoring for SQL Databases group by the Category SQL Backup.

Here's an example of a Monitor View filtered by the 'SQL Backup'

• Your SQL Backups within the SQL databases(s) are listed in Nodinite as resources where the name of the SQL Database becomes the Resource name.

What are the key features for Monitoring SQL Database Size Checks?

• State Evaluation - Monitors and evaluates the state
• Actions - Support for the execution of Remote Actions

What is evaluated for SQL Database Backup?

The different possible evaluated states for your SQL Backup are provided in the table below:

Tip

The System Administrator can override the Monitoring state using the Expected State feature on the Resource within Nodinite.

How do I configure the thresholds for SQL Backups?

Monitoring of SQL Backups is enabled when the checkbox Enable feature Monitoring of SQL backups is checked from within the Remote Configuration dialogue for the Database Monitoring Agent. When checked, all databases for the SQL instance provided by the ConnectionString is monitored.

There are two different ways to configure thresholds for the category SQL Backup:

• Global configuration
• Specific configuration

Global configuration

From the SQL databases tab the global settings are configured. You then need to click on the Backup tab.
Here's an example of the Backups tab with global monitoring thresholds for backup related checks.

You can then edit the available properties.

• Enable Monitoring of SQL Backups - When checked, Monitor for SQL Server backups is enabled, otherwise it is not
• Warning Time Span - The longest allowed timespan for warning on last backup
• Error Time Span - The longest allowed timespan for error on last backup
• Description - user-friendly description for resource

Info

Timespan format is (days.hours.minutes.seconds)

Actions

The Database Monitoring Agent categories SQL Backups and SQL Backups - Specific has support for remote actions. The following Actions exist:

• Edit thresholds
  Here's an example of Remote Actions.

Edit thresholds

The following dialogue is on display after clicking the action button menu item Edit thresholds.

Here's an example of dialogue changing global thresholds to specific thresholds.

The Default values are set using Remote Configuration. Review the Global configuration section of this document for further details.

Note

Category is changed to 'SQL Backups - Specific' when the threshold values are modified.

The time of the last backup taken presents if it exists, else the text will be Missing backup.

The same properties as described in the Global configuration are available and in addition the following can be managed:

• Application - a way of grouping resources (by default the Application used for the SQL Instance is re-used)
• Description - Short description for this specific size check

Save

You must click 'Save' or 'Save and close' for changes to persist. The new settings/thresholds are evaluated on the next synchronization.

Here's an example of the Save options.

Note

Depending on the synchronization interval set for the agent, there might be a delay before the Web Client reflects upon the change. You can force the agent to synchronize the Configuration for all Nodinite Monitoring Agents.

Save and close, save, and close the dialogue.

Cancel, closes the dialogue without saving any changes.

Next Step

Add or manage Monitor View

Related

Database Monitoring Agent
Monitoring Agents
Monitor Views
Resources
SQL Categories