Query to check for free disk space and send an alarm if the disk space exceeds threshold value I would like to create a job which sends an email alert when my server disk space goes beyond a specific threshold value.Since my data files are bigger there is very little free space on disk partitions.


  Is is possible to write a Query which checks all the disks for the
  free disk space and give an email alert if the disk space goes below
  the set 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...