Database growth rate (detailed)


Job details

Name: Database growth rate (detailed)
Platform: Sqlserver
Category: Capacity
Description: Collects size of database files (including transaction log files) to visualize the growth rate for the largest databases.
Long description: Collects size of database files (including transaction log files) to visualize the growth rate for the largest databases.
Version: 1.8
Default schedule: 10 5 1,4 *
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.
collect statistics for databases List of databases (separated by comma) for which statistics will be collected. You can use % (percent sign) to represent wild card characters. If no value specified, statistic for the largest databases will be collected (number of databases is controlled by the parameter “max databases” with the default value 10).
max databases 5 Number of the largest databases for which statistics will be collected (default value 5).
max histr interval 730 The maximum number of days before old history records will be removed from the history table (default 2 years).

Job Summary

Detailed Description

Implementation Details

Dependency Tables and Cleanup Actions

Parameters and Upgrades

Reporting Templates

Conclusion