Monitoring Hard Drive Space

Sunday Jun 25th 2000 by Tanya Stolyar
Share:

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.

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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved