||SQL Server Tips by Gama and Naughter
Applications of XP_ DISKSPACE
The application that seems to be the most obvious is to have a job
checking the free space, every amount of time and emailing the
SysAdmin if it goes below a certain space, considered safe. In this
example, the job will execute every 5 minutes and email the SysAdmin
if the free space is less than 10 gigabytes.
The job is named “check disk space”:
DECLARE @SpaceLeft int
EXEC master..XP_DISKSPACE 'C:', @SpaceLeft OUTPUT
code depot for full script
under 10 Gb', @Body='Check server because the
free space is under 10 Gb'
The code will check for the free space on disk and email the
Sysadmin if this value is less than 10 gigabytes.
The above book excerpt is from:
Turbocharge Database Performance with C++ External Procedures
Joseph Gama, P. J. Naughter