How historical data is retained in Data Warehouse
Suggest changes
PDFs
Data is maintained in Data Warehouse according to a schedule. As data gets older, the data record retention is reduced.
Data Warehouse retains historical data based on the data marts and granularity of the data, as shown in the following table.
Data mart |
Measured object |
Granularity |
Retention period |
Performance marts |
Volumes and internal volumes |
Hourly |
14 days |
Performance marts |
Volumes and internal volumes |
Daily |
13 months |
Performance marts |
Application |
Hourly |
13 months |
Performance marts |
Host |
Hourly |
13 months |
Performance marts |
Switch performance for port |
Hourly |
5 weeks |
Performance marts |
Switch performance for host, storage, and tape |
Hourly |
13 months |
Performance marts |
Storage node |
Hourly |
14 days |
Performance marts |
Storage node |
Daily |
13 months |
Performance marts |
VM performance |
Hourly |
14 days |
Performance marts |
VM performance |
Daily |
13 months |
Performance marts |
Hypervisor performance |
Hourly |
14 days |
Performance marts |
Hypervisor performance |
Daily |
13 months |
Performance marts |
VMDK performance |
Hourly |
14 days |
Performance marts |
VMDK performance |
Daily |
13 months |
Performance marts |
Disk performance |
Hourly |
14 days |
Performance marts |
Disk performance |
Daily |
13 months |
Capacity marts |
All (except individual volumes) |
Daily |
13 months |
Capacity marts |
All (except individual volumes) |
Monthly representative |
14 months and beyond |
Inventory marts |
Individual volumes |
Current state |
1 day (or until next ETL) |
After 13 months (which is configurable), Data Warehouse retains only one record per month instead of one record per day for capacity, performance, and resource data in the following fact tables:
-
Chargeback fact table (dwh_capacity.chargeback_fact)
-
File System Utilization fact table (dwh_fs_util.fs_util_fact)
-
Host fact table (dwh_sa.sa_host_fact)
-
Internal Volume Capacity fact table (dwh_capacity.internal_volume_capacity_fact)
-
Ports fact table (dwh_ports.ports_fact)
-
Qtree Capacity fact table (dwh_capacity.qtree_capacity_fact)
-
Storage and Storage Pool Capacity fact table (dwh_capacity.storage_and_storage_pool_capacity_fact)
-
Volume Capacity fact table (dwh_capacity.vm_capacity_fact)
-
Storage Node Hourly Performance (storage_node_hourly_performance_fact) and Storage Node Daily Performance (storage_node_daily_performance_fact) fact tables