Monitors MSSQL longest transaction time.
MSSQL must be installed on the target machine.
|Frequency||Warning Threshold||If the metric value satisfies the condition defined along with Warning Threshold value, then a notification is sent to the user.|
|Critical Threshold||If the metric value satisfies the condition defined along with Critical Threshold value, then a notification is sent to the user.|
|Alert||The alert value can be set to either Yes or No. If it is Yes, then an alert message is sent to the user.|
|Description||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.|
|Monitor Name||G2 MSSQL Database Transactions Monitor|
|Metric||Input Value||Range of Values|
|Frequency||2||1 – 1440 (mins)|
|Warning Repeat Count|
|Critical Repeat Count|