Monitoring dimension data growth over time
About this task
Periodically, you should review the Database Table Size report, which contains details on the daily and monthly growth patterns of dimension data.
Note: Immediately after installation or configuring
a
Whitelist + Observed Values
, Discover recommends reviewing this report
on a daily basis. Over time, you may lengthen the period between review.Procedure
- From the Portal menu, select .
- From the drop-down, select
Dimension
. - Set Focus Period to an appropriate date range.
- Download report.
- Load into Excel.
- Sort by the Daily growth, Monthly growth, or row count column to identify the fastest-growing or largest dimensions.
- Based on the values for specific dimension tables, you
can determine whether configuration changes must be made to the dimension.
- The tables of interest are listed as
TD_DIMENSION_XXX
, whereXXX
is a numeric identifier.Note: The_LOG
table references indicate dimensions that have logging enabled to capture detected values.
- The tables of interest are listed as
Results
See "System Status" in the Unica Discover Administration Manual.