Query to check for free disk space and send an alarm if the disk space exceeds threshold value
Check out this article:
Disk Space Monitoring: How To

And do not forget to monitor other crucial metrics: log file usage, cpu, blocking and so on...