The Databases - Dynamic Data File Group Growths Remaining alarm becomes active when a non fixed size data file in any database is in danger of running out of space to grow. This alarm is raised when a data file is almost full and the file cannot automatically grow enough to relieve the problem. Once a data file fills completely, depending on the state of other data files within the file group, attempts to update data in that database may fail. This alarm takes into account the amount of free space currently on the disk that the file resides on.
The alarm is raised when the number of growths remaining, given the files growth settings and the amount of free disk space available, falls below a threshold.
This alarm can occur when a data file is filling up and the file is approaching, or has reached, its MaxSize settings and is defined with Auto Grow=Yes and there are a limited number of growths that can occur before an out of disk space condition occurs.
When the alarm is raised
View the Data Files page on the SQL Server | Databases Drilldown. Check for files with Auto Grow=Yes; files in danger of filling will have a low Free Pct figure.
To resolve this problem, free up disk space on the disk that the file resides on.
This alarm is raised in the following circumstances: