Longest Transaction Running Time (LongestTransactionRunningTime)
The length of time (in seconds) since the start of the transaction that has been active longer than any other current transaction. This counter only shows activity when the database is under read committed snapshot isolation level. It does not log any activity if the database is in any other isolation level.
BMC PATROL properties
Property | Default value |
|---|---|
Application class | MSSQL_SERVER_PERFMON_TRANSACTIONS |
Command type | NA |
Platform | All |
Icon style | Graph |
Unit | Sec |
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
Property | Default value |
|---|---|
Monitor type | MS SQL Server Perfmon Transactions |
Key Performance Indicator | No |
Monitor for abnormalities | No |
Graph by default | No |
Availability | No |
Response time | No |
Normal distribution | No |
Statistical | No |