Database disk space usage


Job details

Name: Database disk space usage
Platform: Sqlserver
Category: Capacity
Description: Checks free space on drives where all data and transaction log files are defined. Drives where no data files exist will be ignored.
Long description: Checks free space on drives where all data and transaction log files are defined. Drives where no data files exist will be ignored.
Version: 1.6
Default schedule: 10 5,15 * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘1999′ & hasengine=‘YES’ & engine_edition = ‘Microsoft SQL Server’ & eng_inst_priv = 0]

Parameters

Name Default value Description
warning threshold 6000 The check will give a warning when disk space falls below this value (in MB).
alarm threshold 1000 The check will give an alarm when disk space falls below this value (in MB).

Job Summary

select drive_letter, type, db_name, logic_name, file_name, size_mb, growth_kb * 8 as Growth, case max_size when '-1' then 'Unrestricted' else round(cast((max_size / 1024.0) as float), 2) end as MaxSize from dbw_file_usage_detailed order by size_mb desc

Task Details

Reporting Templates

Specific Output Presentations Include:

Dependencies

Implementation

Upgrade and Maintenance

The proactive approach in monitoring and quick alerting allows for optimal database management, preventing potential system failures due to insufficient disk space.