Database growth rate (aggregated)


Job details

Name: Database growth rate (aggregated)
Platform: Sqlserver
Category: Capacity
Description: Collects size of all database files (including transaction log files) to visualize the growth rate for all databases.
Long description:
Version: 1.21
Default schedule: 10 5 5 *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2000′ & hasengine=‘YES’ & eng_inst_priv = 0 & (engine_edition = ‘Microsoft SQL Server’ engine_edition = ‘Azure SQL Managed Instance’)]

Parameters

Name Default value Description
min histr interval 360 The minimum number of minutes before a new history record will be collected in the history table.

Job Summary

SELECT dbid, name, filename, ROUND((size/1024.0)*8, 1) AS size FROM master..sysaltfiles ORDER BY 1

Dependencies and SQL Implementation Details

The job has specific dependencies on SQL Server system tables and custom tables created for tracking historical data. Below is detailed information about these dependencies and their importance:

Reporting and Visualization

The job provides a visualization report on the database’s growth rate which can be crucial for presentations and audits:

Upgrade Considerations

System Requirements and Compatibility

Installation and Maintenance

The outlined structure and detailed analysis of the DBWatch job underscore its importance in proactive database capacity management and operational integrity.