N-central Help

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 SolarWinds 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.