Table size collector

Name:	Table size collector
Platform:	Sqlserver
Category:	Capacity
Description:	Collects table (HEAP and CLUSTER type) size statistics.
Long description:	Collects table (HEAP and CLUSTER type) size statistics..
Version:	1.1
Default schedule:	20 5 6 *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[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
history threshold	365	The number of days the statistics will be kept in the history table.
collect record count stat	NO	If “YES”, the performance view sys.dm_db_index_physical_stats is queried in DETAILED mode (to collect information from the record_count column) for the largest object.
max objects per graph	5	The maximum number of objects visualized in the report graphs.
table list		List of tables (separated by comma, in format

Feedback