The Oldest Open Transaction (Minutes) alert provides the time (in minutes) that the longest running transaction in the database has used since issuing the BEGIN TRANSACTION statement.

To enable alerting when this metric is outside its established baseline, click the Baseline Thresholds Enabled (as percentage of baseline) check box in the Alert Configuration window.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >