Monitoring Database disk space

An article Data files: To Autogrow Or Not To Autogrow? recommends NOT to rely on auto-grow, because it causing delays in unplanned times.

We should mtonitor database files(both data and log), and if they close to max capacity, manually increase the size.

 However it doesn’t give references, how to monitor the free space inside databases.
I’ve tried to look how to do it. 

It can be done manually using   

execute sp_spaceused for the database in question or 

sp_SOS (can be downloaded from

Alternatively you can run SQL commands as suggested in Http:// by Michael Valentine Jones

[FREE_SPACE_MB] = convert(decimal(12,2),round((a.size-fileproperty(,’SpaceUsed’))/128.000,2)) 
from dbo.sysfiles a
More useful article Monitor database file sizes with SQL Server Jobs describes how to setup monitoring

 Finally I found the excellent article

Managing Database Data Usage With Custom Space Alerts, that can be followed even support personnel without much DBA experience.