Database space check


Job details

Name: Database space check
Platform: Sybase
Category: Capacity
Description: Checks the amount of free space in all databases.
Long description:
Version: 2.1
Default schedule: 10 5,17 * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sybase’]/instance[maj_version > ‘14′ & hasengine=‘YES’]

Parameters

Name Default value Description
ignore databases Names of databases which will be ignored (comma separated list).
min. free space (MB) 2000 No warning or alarm will be triggered if the amount of free space in a device fragment is higher then this value.
warning threshold pct. 95 The check will give a warning when the amount of free space in a device fragment is lower then the parameter value “min. free space (MB)”, and the percentage of used space exceeds the threshold value “warning threshold pct.”.
alarm threshold pct. 97 The check will give an alarm when the amount of free space in a device fragment is lower then the parameter value “min. free space (MB)”, and the percentage of used space exceeds the threshold value “alarm threshold pct.”.

Job Summary

EXEC dbw_database_space_check;

Detailed Description

This dbWatch Control Center monitoring job, specifically designed for Sybase instances with version greater than 14 that have an engine, performs detailed checks on database space usage. The job:

Parameters Definition Overview

Implementation Logic

The procedure involves creating several temporary tables and procedures to accumulate space usage details across different database segments and device fragments. Specific actions within the procedure include:

Dependencies and Cleanup

The job depends on the existence and creation of specific tables and stored procedures which help in generating detailed space utilization statistics:

Upon failure, the cleanup process involves dropping these stored procedures and tables to ensure there are no remnants from failed executions.

Reporting and Alerts

The job is designed to provide extensive reporting capabilities, which are configurable and could include:

This job ensures a robust monitoring mechanism is in place to help database administrators manage space effectively and mitigate risks associated with space exhaustion.