"I'm encountering an issue with configuring alerts in Microsoft SQL Server 2017.
- Attempting to execute a console application triggered by the "Long Runtime Transaction" counter in an alert.
- The alert is triggering correctly only for the "Falls Below" condition but not for the "Rises Above" condition.
- Using a 'Waiting delay' query to verify the functionality of the counter.
Isolation level
Referred to created alert
https://www.sqlserverlogexplorer.com/set-long-running-transaction-alert/
