Connections Remaining (ConnectionsRemaining)
Monitors the number of user connections available on an SQL Server (excluding the system connections). This parameter uses the master..sys.configurations table to determine the maximum number of user connections that are allowed and the SQL Server General Statistics counter, User Connections, to calculate the number of connections remaining.
BMC PATROL properties
Property | Default value |
|---|---|
Application class | MSSQL_SERVER_SERVER_HEALTH |
Command type | NA |
Platform | All |
Icon style | Graph |
Unit | Number (#) |
Border range | Undefined |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | Inherited |
Active at installation | No |
Parameter type | Consumer |
TrueSight/ BMC Helix Operations Management properties
Property | Default value |
|---|---|
Monitor type | MS SQL Server Health |
Key Performance Indicator | No |
Monitor for abnormalities | No |
Graph by default | No |
Availability | No |
Response time | No |
Normal distribution | No |
Statistical | No |