This procedure helps you to know when the database space free is over the @percent filled up and the disk space left is below @M_free_high bigint
OR the disk space left is below < @M_free_low
Example: EXEC msdb.dbo.[get_space_free] 2000, 15000, 80
This means 'Give me information of all databases filled at 80% capacity with less than 15 Mbytes (15 Gbytes) of disk space
OR just all database drives with less than 2000 Mbytes (2 gbytes)'
Very useful to prevent DISK FULL when database grows.
This is the display: