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