The Databases - Dynamic Data File Growths Remaining is SQL Server alarm raised when a SQL Server Data File has limited number of growths remaining.
Every SQL Server Data File has Autogrowth and Maximum File Size properties which the Diagnostic Server takes in consideration as well as free logical disk space when calculating number of growths.
The Growths Remaining value is based on output of the QS_Files.sql script (MaxSizeMb, TotalMB and GrowthIncrementValue columns) which is located in the <Quest Software>\Diagnostic Server\Agent\conf\Package\sqlserver_spotlight\200* folder on the Diagnostic Server which in its turn retries data from the sys.database_files (
http://msdn.microsoft.com/en-us/library/ms174397.aspx) and showfilestats system objects.
When the alarm raised, you need to open Databases drilldown, select all databases, then open Data Files sub-tab and sort the data by increasing Growths remaining column.
Consider changing mentioned properties for data files showing lowest growths remaining values or/and allocate more disk space for data files to grow.
