How to Detect and Clear Long-Running Transactions

A single, long-running transaction can prevent the log from being truncated. This occurs because Adaptive Server only dumps the inactive portion of a transaction log. It is important to detect the presence of these transactions and act accordingly. Otherwise, the transaction log eventually fills up, even if dump transaction commands are executed.