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

Non-equal file growth detected

For SQL Server 2016 and older, the SQL Server data files did not grow equally in a round-robin fashion unless trace flag 1117 was enabled. This can decrease performance.

To query the Performance Store database for SQL Servers older than SQL Server 2016 with non-equal file growth detected, use:

select s.*
from dbo.v_servers s
outer apply string_split(isnull(s.trace_flags, ''), ',') t
where convert(int, substring(s.sql_server_version, 0, charindex('.', s.sql_server_version))) <= 12
and trim(t.value) != '1117'

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