Data file size check


Job details

Name: Data file size check
Platform: Sqlserver
Category: Capacity
Description: Checks the remaining space for all databases where the data files are set with limited growth rate (max size not unlimited).
Long description: Checks the remaining space for all databases where the data files are set with limited growth rate (max size not unlimited).
Version: 1.9
Default schedule: 5 7,12,17 * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version = ‘2000′ & hasengine=‘YES’ & engine_edition = ‘Microsoft SQL Server’]

Parameters

Name Default value Description
ignore databases model List of databases (separated by comma) which will be ignored.
warning threshold 90 Percentage value when a warning is triggered.
alarm threshold 95 Percentage value when an alarm is triggered
minimum free space 10000 The minimum free space (in MB) left for data file(s) to grow. If the amount of free space falls below this parameter value, and at the same time the amount of free space in percent falls below the “warning/alarm threshold” parameter value, the check will return a WARNING/ALARM.

Job Summary

Implementation Details

Job Output

Database Group ID File Count Allocated Space Lowest Value of Max Size Total Max Size Pct Allocated
Database Name Group ID Number of Files in Group Space Used (MB) Minimum Configured Max Size (if applicable) Configured Max Size % of Max Size Used

Job Dependencies and Schedule

Enhancements and Maintenance

This job is a crucial part of the database monitoring landscape, especially for systems where data growth is highly dynamic and needs constant supervision.