QL Server version 7.0 +
This script monitors available disk space for the specified drive.
If a drive name is not specified in @drivename parameter the
usp_dba_diskspace_monitor stored procedure will check all drives against a space limit (MB) passed through @spacelimit parameter.
If available disk space is less then @spacelimit an alert gets raised and sent to an operator.
A schedules job ‘# DBA – Monitor Disk Space’ allows you to automate the
monitoring. The run schedule can be modified according to DBA’s
requirements.
The diskspace_monitor.sql script consist of:
- create a new message
- create a new alert
- stored procedure ‘usp_dba_diskspace_monitor’
- scheduled job
Download diskspace_monitor.SQL