SQL Instances Connection Status (SQLInstsConnectionStatus)
Displays the sql connection status for the monitored sql instances.
- 0- All SQL instances connected successfully
- 1- Connection failed for at least one SQL instance
Generates annotation - ✅️
BMC PATROL properties
Property | Default value |
|---|---|
Application class | MSSQL_SERVER_INSTANCE_CONTAINER |
Command type | NA |
Platform | All |
Icon style | State Boolean |
Unit | 0- All SQL instances connected successfully 1- Connection failed for at least one SQL instance |
Border range | 0 to 1: Alarm |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | Inherited |
Active at installation | Yes |
Parameter type | Consumer |
TrueSight/ BMC Helix Operations Management properties
Property | Default value |
|---|---|
Monitor type | MS SQL Server Instances |
Key Performance Indicator | No |
Monitor for abnormalities | No |
Graph by default | Yes |
Availability | Yes |
Response time | No |
Normal distribution | No |
Statistical | No |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*