- 3 minutes to read

Managing SQL Instance(s)

Gain full control and visibility over your SQL Server instances with Nodinite. This page explains how to monitor, manage, and optimize your SQL Server availability using the Database Monitoring Agent, providing actionable insights and rapid troubleshooting.

✅ Proactive monitoring and instant alerts for SQL Server availability
✅ Centralized management of all SQL Server instances
✅ Remote actions for rapid troubleshooting and control
✅ Category-based grouping for easy resource management

This monitoring feature helps you get alerted when the SQL Server instance is unavailable.

The Database Monitoring Agent continuously monitors your configured SQL Instance(s). Each monitored SQL Instance is represented in Nodinite as a Resource. The evaluated state of each SQL Instance is visible in Monitor Views and can trigger external alerts using any installed Alarm Plugins.

The checks for SQL Instances are grouped by the Category SQL Instance.

Here's an example of a Monitor View filtered by the 'SQL Instance' category.

Your SQL Instances are listed in Nodinite as resources, where the Display name of the SQL Instance configuration becomes the Resource name.

graph LR subgraph "Configuration" c["fal:fa-code 1 SQL Server Instance"] --> r[fal:fa-lightbulb 1 Resource] end

Each configuration is manifested as a Resource.

What are the key features for Monitoring SQL Instance?

State Evaluation – Monitors and evaluates the state of each SQL Instance
Actions – Support for the execution of Remote Actions

What is evaluated for SQL Instance?

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

State	Status	Description	Actions
Unavailable	Resource not available	Evaluation of the 'SQL Instance' is not possible either due to network or security-related problems	Review prerequisites
Error	Error state raised	The SQL Instance is unavailable or cannot be reached	Edit configuration
OK	Online	The SQL Server instance is online, operational and accessible	Edit configuration

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

Configuration

Configuration of SQL Instances is described in the Edit configuration user guide.

Actions

The Database Monitoring Agent supports remote actions. The following Actions are available:

Details

Example of viewing SQL Server log details.
View SQL Server Log

View SQL Server Log

You can view the current log for a SQL Server Instance. To reduce network traffic, the result is displayed using pagination.

Example of viewing the SQL Server log.