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
![](https://secure.gravatar.com/avatar/7af7ed9716f111472c91e1a974400baf?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
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/