Filegroups growth rate


Job details

Name: Filegroups growth rate
Platform: Sqlserver
Category: Capacity
Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined to a SQL Server instance.
Long description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is used to execute T-SQL statements against dbo.sysfiles table in every database defined to a SQL Server instance.
Version: 2
Default schedule: 0 * * *
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 dbname "Database", round(convert(float,sum(size))/1024.,2) "Total size", round(convert(float,sum(spaceused))/1024.,2) "1 Space used", round(convert(float,sum(size)-sum(spaceused))/1024.,2) "2 Free space" from dbw_filegroups_growth group by dbname order by 2 desc

Job Configuration and Implementation

Reporting and Visualization

Job Dependencies and Triggers

Summary

This dbWatch job is an essential component for maintaining operational efficiency and stability in SQL Server environments by monitoring database filegroups’ space usage and growth trends. It helps ensure that adequate database resources are available and provides critical data that informs capacity planning and management decisions.