Logical Connections (LogicalConnections) - Documentation for BMC PATROL for Microsoft SQL Server 9.6
Liam Parker 
Number of logical connections to the system.
The main purpose of logical connections is to service multiple active result sets (MARS) requests. For MARS requests, every time that an application makes a connection to SQL Server, there may be more than one logical connection that corresponds to a physical connection. When MARS is not used, the ratio between physical and logical connections is 1:1. Therefore, every time that an application makes a connection to SQL Server, logical connections will increase by 1.
BMC PATROL properties
Property | Default value |
|---|---|
Application class | MSSQL_SERVER_PERFMON_GENERAL_STATISTICS |
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 | Yes |
Parameter type | Consumer |
TrueSight/ BMC Helix Operations Management properties
Default value | |
|---|---|
| Monitor type | MS SQL Server Perfmon General Statistics |
Key Performance Indicator | No |
| Monitor for abnormalities | No |
| Graph by default | No |
| Availability | No |
| Response time | No |
| Normal distribution | No |
| Statistical | No |
