Database growth rate (detailed)


Job details

Name: Database growth rate (detailed)
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.2
Default schedule: 10 5 1,4 *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version = ‘2000′ & hasengine=‘YES’ & (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 db_name, db_file_size, tr_log_size, histr_date
FROM dbw_db_size_histr_detailed
ORDER BY db_name, histr_date;

Details

Dependencies

Execution Logic

Reporting Template

Scheduled Execution

Note: This detailed monitoring is configured for instances running Microsoft SQL Server 2000 and Azure SQL Managed Instance by specifying the database types and conditions in the component query.