Database growth rate (detailed)
Job details
| Name: |
Database growth rate (detailed) |
| Platform: |
Sybase |
| Category: |
Capacity |
| Description: |
Collects database growth rates statistics. |
| Long description: |
|
| Version: |
1.3 |
| Default schedule: |
10 6 2,6 * |
| Requires engine install: |
Yes |
| Compatibility tag: |
.[type=‘instance’ & databasetype=‘sybase’]/instance[maj_version > ‘11′ & hasengine=‘YES’] |
Parameters
| Name |
Default value |
Description |
| min histr interval |
360 |
The minimum number of minutes before a new history record will be collected into the history table. |
| max databases |
10 |
The number of databases for which the space usage statistics will be collected into the history table (ordered by space used). |
Job Summary
- Purpose: The purpose of this job is to collect and report on database growth rates in detail, offering insights into the size and space usage over time of different databases.
- Why: This job is crucial for managing and projecting database capacity, understanding trends in database growth, and preparing for necessary infrastructure adjustments. By monitoring these statistics, operational efficiency and planning are significantly enhanced.
- Manual checking: You can manually check this in the database by issuing the following SQL command:
select db_id as "database id", db_name as "database", size_mb as "total size", used_mb as "space used", segmap_info as "segmap type", histr_date as "statistics collected" from dbw_db_size_tab order by used_mb desc;
Detailed Description
- This monitoring job provides a detailed view of database growth rates by collecting and presenting statistics on database size and space usage.
- It uses procedures to collect current database sizes and maintains a historical log for trend analysis.
Implementation Details
- The job involves creating tables to store current and historical database sizes and a procedure for data collection.
- The procedure calculates sizes and growth, determining when new historical entries should be made based on defined intervals.
Dependencies
- The main task has dependencies on itself and a few tables (`dbw_db_size_tab` and `dbw_db_size_tab_histr`) which hold the size statistics and historical data.
Cleanup and Robustness
- Cleanup code includes the commands to drop the created procedure and tables if installation fails, ensuring that no unwanted or partial configurations remain.
- This ensures that all components of the task are properly removed on failure, maintaining system integrity.
Report Generation
- The job generates detailed reports that include:
- Tables showing growth rates of databases.
- Charts illustrating space usage, including both used and free space for databases.
- Historical growth data visualizations.
| Database Reports Overview |
| _ |
_ |
| Report Title |
Database Growth Rate |
| Description |
Detailed information about growth rates for all databases. Includes tabular data and graphical presentations for better visualization. |
Schedule
- Default job schedule is set to run on specific times (10:06 AM on every 2nd and 6th day of the month), while the report has its own schedule, running hourly.
Enhancements and Installation
- The job supports express installation and will force install, making deployment straightforward.
- Compatibility checks ensure that the job only installs on suitable Sybase database instances.
Overall, this monitoring job provides essential data for effective database capacity management and planning in a detailed and systematic manner, appropriate for databases expecting growth or needing careful management of space resources.