Generic SQL Server service

The Generic SQL Server service monitors the availability of the port where the MS SQL Server application runs. The availability of the port, which is determined by the service testing the port's connectivity, indicates that the MS SQL Server application is running. This service also measures the DNS resolution and the round trip time of the initial connection request and response. The availability results of the TCP service are then reflected on the status dashboard for the Generic SQL Server service.

You can set a maximum of three instances of this service on a device, with each instance monitoring a different port on the device.

The Generic SQL Server service does not use the Warning state.

Service Type	Generic TCP
Instances on a Device	3
Supported Systems/Applications	Microsoft SQL Server
Device Class	Server - Generic, Workstation - Generic, Other, Printer, Scanner/Camera, Switch/Router, Laptop - Windows, Server - Windows, and Workstation - Windows
Monitored By	Windows probe, central server
Scan Interval	5 minutes
Timeout Value	The time in seconds that the N-able N-central server waits before considering the test a failure. The default is 30 seconds.
Port Number	The TCP port number used to monitor the Generic SQL service is 1433.

Generic SQL server thresholds

Status Detail	Description
Generic SQL Server Availability	The threshold that determines the availability of the port.
Round Trip Time (ms)	The time in milliseconds for a request to be sent and received.
DNS Resolution	The threshold that determines whether the device name can be resolved. If an FQDN has been specified, the service searches for its IP address. If the IP address is found, the state is Normal. Otherwise, it is Failed, based on the default settings. If an IP address has been specified, the service checks only the IP address's format. If the format is correct, the state is Normal. Otherwise, it is Failed, based on the default settings.

Status Detail

Description

Generic SQL Server Availability

The threshold that determines the availability of the port.

Round Trip Time (ms)

The time in milliseconds for a request to be sent and received.

DNS Resolution

The threshold that determines whether the device name can be resolved.

If an FQDN has been specified, the service searches for its IP address. If the IP address is found, the state is Normal. Otherwise, it is Failed, based on the default settings.

If an IP address has been specified, the service checks only the IP address's format. If the format is correct, the state is Normal. Otherwise, it is Failed, based on the default settings.