Hi Jason, thanks for the comments, all advice is greatly appreciated.

1. Good point, this will allow us to more easily deploy the process to servers with different threshold requirements.

2. The purpose of these alerts is to notify us to the amount of free space in the data files, not the free drive space. We can then proactively manage growth in the data files more effectively, rather than relying on SQL to automatically grow the data files for us. You are correct though, an alert to notify us of full drives is highly recommended as well. You can't increase data and log files size if you don't have any capacity to do so. 🙂

Thanks for the input.