SDK User-Defined Database Objects Version 10.3.00P13

Data Retention Periods for SDK Database Objects > SDK User-Defined Database Objects

Version 10.3.00P13

SDK User-Defined Database Objects

The data retention period for various database tables often can be modified to maintain reasonable table sizes. Data retention periods can be modified for historical and performance data. Reference the following sections for details:

• Capacity: Default Retention for Basic Database Tables

• Capacity: Default Retention for EMC Symmetrix Enhanced Performance

• Capacity: Default Retention for EMC XtremIO

• Capacity: Default Retention for Dell EMC Elastic Cloud Storage (ECS)

• Capacity: Default Retention for Microsoft Windows File Server

• Capacity: Default Retention for Pure Storage FlashArray

• Cloud: Default Retention for Amazon Web Services (AWS)

• Cloud: Default Retention for Microsoft Azure

• Cloud: Default Retention for OpenStack Ceilometer

Capacity: Default Retention for Basic Database Tables

Table Description	Table Name	Default Retention	Notes
File system log	aps_file_system_log	6 months	KEEP_FILE_SYSTEM_LOG_MONTHS
LUN performance log	apt_lun_perform_log	504 hours	KEEP_LUN_RAW_PERFORM_HOURS
Array group log	aps_array_group_log	12 months	KEEP_ARRAY_GROUP_LOG_MONTHS
Array port statistics log	aps_array_port_stats_log	1 day	KEEP_ARRAY_PORT_STAT_LOG_DAYS
Array port statistics daily log	aps_array_port_stats_daily_log	2 months	KEEP_ARRAY_PORT_STAT_DAILY_LOG_MONTHS
Capacity chargeback log	aps_chargeback_log	24 months	KEEP_SRM_CHARGEBACK_LOG_MONTHS
Host processing log	apt_host_process_log	15	KEEP_HOST_PROCESS_LOG_DAYS

Capacity: Default Retention for EMC Symmetrix Enhanced Performance

Table Description	Table Name	Default Retention	Notes
Array Performance	SDK_esym_ARRAY_PERF	21 days	To modify the retention period, see Data Retention Periods for SDK Database Objects.
Back-end Director Performance	SDK_esym_be_director_PERF	21 days
Database Performance	SDK_esym_database_PERF	21 days
Device Group Performance	SDK_esym_device_group_PERF	21 days
Disk Group Performance	SDK_esym_disk_group_PERF	21 days
Disk Performance	SDK_esym_disk_PERF	21 days
Disk Tech Pool Performance	SDK_esym_disk_tchpool_PERF	21 days
Front-end Director Performance	SDK_esym_fe_director_PERF	21 days
Front-end Port Performance	SDK_esym_fe_port_PERF	21 days
Storage Group Performance	SDK_esym_storage_grp_PERF	21 days
Storage Tier Performance	SDK_esym_storage_tier_PERF	21 days
Thin Pool Performance	SDK_esym_thin_pool_PERF	21 days
Thin Tier Performance	SDK_esym_thin_tier_PERF	21 days
Array's Cache Usage Performance	sdk_esym_array_cache_usage	21 days

Capacity: Default Retention for EMC XtremIO

Table Description	Table Name	Default Retention	Notes
XtremIO Data Reduction Rate	sdk_exio_datareductionrate	15	To modify the retention period, see Data Retention Periods for SDK Database Objects.

Capacity: Default Retention for Dell EMC Elastic Cloud Storage (ECS)

Table Description	Table Name	Default Retention	Notes
ECS Storage Array Performance	sdk_decs_ecsstg_ary_stats	21	To modify the retention period, see Data Retention Periods for SDK Database Objects
ECS Replication Group Performance	sdk_decs_ecsrep_grp_stats	21	To modify the retention period, see Data Retention Periods for SDK Database Objects
ECS Node Performance	sdk_decs_ecsnode_stats	21	To modify the retention period, see Data Retention Periods for SDK Database Objects
ECS Node's Disk Performance	sdk_decs_ecsnodedisk_stats	21	To modify the retention period, see Data Retention Periods for SDK Database Objects
ECS Storage Pools Performance	sdk_decs_ecsstg_pls_stats	21	To modify the retention period, see Data Retention Periods for SDK Database Objects

Capacity: Default Retention for Microsoft Windows File Server

Table Description	Table Name	Default Retention	Notes
History and Performance Table for Windows File Systems	sdk_msws_filesystem_perf	21 months	To modify the retention period, see Data Retention Periods for SDK Database Objects.
History and Performance Table for Windows Cifs Shares	sdk_msws_cifsshare_perf	21 months	To modify the retention period, see Data Retention Periods for SDK Database Objects.
History and Performance Table for Windows NFS Server	sdk_msws_nfs_statistics	21 months	To modify the retention period, see Data Retention Periods for SDK Database Objects.
History and Performance Table for Windows Event Log Details	sdk_msws_eventlog_details	30 months	To modify the retention period, see Data Retention Periods for SDK Database Objects.

Capacity: Default Retention for Pure Storage FlashArray

Table Description	Table Name	Default Retention	Notes
Array Performance	SDK_PURE_STORAGEARRAY_PERF	21 days	To modify the retention period, see Data Retention Periods for SDK Database Objects.

Cloud: Default Retention for Amazon Web Services (AWS)

Table Description	Table Name	Default Retention	Notes
Billing Record Tag	SDK_aws_billing_rec_tag	366 days	To modify the retention period, see Data Retention Periods for SDK Database Objects.
Mapping from any resource ID or name to one of many different entities (or none at all)	sdk_aws_resource_map	999999 days	To modify the retention period, see Data Retention Periods for SDK Database Objects
S3 bucket usage	sdk_aws_s3_bucket_usage	999999 days	To modify the retention period, see Data Retention Periods for SDK Database Objects
Billing Record	sdk_aws_billing_record	367 days	To modify the retention period, see Data Retention Periods for SDK Database Objects. Note: The retention period for the billing record data must be one day more than the billing record tag data to ensure that the dependent tag data is removed before purging the billing record.

Cloud: Default Retention for Microsoft Azure

Table Description	Table Name	Default Retention	Notes
Resource Mapping from any resource ID or name to one of many different entities (Virtual Machines or Storage Accounts)	sdk_msaz_resourcemap	999999 days	To modify the retention period, see Data Retention Periods for SDK Database Objects.

Cloud: Default Retention for OpenStack Ceilometer

Table Description	Table Name	Default Retention	Notes
Instance Metrics	sdk_oscm_instance_metrics	15	To modify the retention period, see Data Retention Periods for SDK Database Objects.
Network Metrics	sdk_oscm_network_metrics	15	To modify the retention period, see Data Retention Periods for SDK Database Objects.
Disk Metrics	sdk_oscm_disk_metrics	15	To modify the retention period, see Data Retention Periods for SDK Database Objects.