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

Unequal filegrowth

Databases where multiple data files withing the same file group is having an unequal filegrowth.

To query the Performance Store database for databases with unequal filegrowth, use:

select distinct s.server_name, s.database_name, s.file_group
from
(
	select distinct f.server_name, f.database_name, f.file_group, f.size_mb
	from dbo.v_database_files f
	where f.file_type = 'ROWS'
) s
group by s.server_name, s.database_name, s.file_group
having count(*) > 1

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