Microsoft best practice is to resize the DB Filesizes (.mdf, .ndf and .ldf) manually and not let grow them autmatically, because the resizing-process costs Performance. So i need an alert, if the free space in a DB - File is smaller than a certain Percentage. The Percentages can be calculated from the 2 values (CurrentSizeMB and SpaceUsedMB) of this script: Select DB_NAME() AS [DatabaseName], Name, physical_name, size/128.0 AS CurrentSizeMB, CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS SpaceUsedMB From sys.database_files Database Files -> Transaction Log File Usage (%) Threshold and Database Files -> Database File Usage (%) Threshold the percentuage is not calculated to the CurrentSizeMB (file size), but to the "max growth size". An other (suboptimal) solution of my problem can be, that every time Autogrowth incrases the size of a Database-file this triggers an Alarm. So i know that i must watch them, to don't run in problems with my "max growth size" limit or with my free space on Harddisk. This problem i had discussed in case #610678 I cannot use this counters, because they have absolut values and not percentage: - Data Files(s) Size - Log File(s) Size - Total Size - Total Size: Percent change 24 Hrs | 
