I need to receive an email when free drive space on E: or H: becomes less than 20%
I know that can be achieved by setting up a job that executes PowerShell or T-SQL scripts on a schedule, that checks for free drive space and sends an alert email when drive space is low
But the question is – can same task be achieved using just an Alert ?
There is alert type "SQL Server performance condition alert"
Is there an Object / Counter that can help to check for drive space and fire this alert if its value "Falls Below" specified threshold ?