Skip to main content
How can we help?
< All Topics
Print

High VLF count

To query the Performance Store database for databases with a VLF count greater than 100, use:

select d.*
from dbo.v_databases d
where d.vlf_count > 100
and d.sample_id = '[sample_id]'
and d.server_name = '[server_name]'

High VLF count will result in larger failover- and restore times.

To reduce the VLF count, shrink the database log file and change the log file auto growth accordingly.

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents