Alerts for high virtual log file count
Alert on high transaction log virtual log file count. Also being able to configure the thresholds to be alerted on.
4
votes
Anonymous
shared this idea
Alerts can be raised when Virtual Log File count exceeds a given threshold as of Version 14.0.41 (January 21, 2025).
The alert is disabled by default and can be enabled in the alert configuration page.
-
Matthew Flatt
commented
Hi, thanks for the suggestion. While this isn't available out of the box, it can be achieved by using a custom metric - I think this one should suit your needs:
http://sqlmonitormetrics.red-gate.com/excessive-virtual-log-files-in-transaction-log/