> Services > SQL > Generic SQL Server Service

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 domain name system (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 MSP 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.