What You Should Know Before Installing Capacity Analyst
Go Up to Getting Started with the Capacity Analyst
When you install the Analyst, several IDERA-generated stored objects are pushed onto the database server:
These objects are as follows:
Contents
SQL SERVER
Procedures
eas_apply_collection_filter |
eas_apply_collection_schedule |
eas_apply_purge_condition |
eas_apply_refresh_stats_condition |
eas_create_collection |
eas_delete_collection |
eas_get_collection_metric_info |
eas_get_metric_query |
eas_get_metric_query_ex |
eas_get_metric_query_ex1 |
eas_get_purge_condition |
eas_get_purge_status |
eas_get_refresh_stats_condition |
eas_get_refresh_stats_status |
eas_is_admin |
eas_is_auto_purge_set |
eas_is_collection_available |
eas_is_collection_scheduled |
eas_is_filter_all_set |
eas_list_perf_stats |
eas_list_wait_events |
eas_purge_data |
eas_refresh_stats |
eas_resolve_collection_objects |
eas_resolve_datastruct |
eas_resolve_indexes |
eas_resolve_perfstats |
eas_resolve_tables |
eas_resolve_waitevents |
eas_run_collection |
eas_run_datastruct |
eas_run_perfstats |
eas_run_waitevents |
eas_set_auto_purge_status |
eas_set_collection_status |
eas_set_refresh_stats_status |
eas_update_schedule_dates |
Foreign Keys
eas_collection_fk1 |
eas_collection_fk2 |
eas_collection_object_fk1 |
eas_collection_object_fk2 |
eas_filter_fk1 |
eas_filter_fk2 |
eas_group_recfk |
eas_map_fk1 |
eas_object_fk |
eas_object_type_fk |
eas_option_fk1 |
eas_property_fk1 |
eas_property_fk2 |
eas_schedule_fk |
eas_statistic_fk1 |
eas_statistic_fk2 |
eas_statistic_fk3 |
Tables
eas_collection |
eas_collection_object |
eas_collection_sql |
eas_database |
eas_filter |
eas_group |
eas_map |
eas_object |
eas_object_type |
eas_option |
eas_option_type |
eas_property |
eas_schedule |
eas_statistic |
eas_version |
Metadata
eas_column_map_insert |
eas_database_insert |
eas_group_insert |
eas_object_type_insert |
eas_option_insert |
eas_option_type_insert |
eas_version_insert |
DB2
Foreign Keys
eas_col_obj_fk1 |
eas_col_obj_fk2 |
eas_collection_fk1 |
eas_collection_fk2 |
eas_filter_fk1 |
eas_filter_fk2 |
eas_group_recfk |
eas_map_fk1 |
eas_object_fk |
eas_object_type_fk |
eas_option_fk1 |
eas_property_fk1 |
eas_property_fk2 |
eas_schedule_fk |
eas_statistic_fk1 |
eas_statistic_fk2 |
eas_statistic_fk3 |
Index
eas_collection_idxs |
eas_collection_object_idxs |
eas_filter_idxs |
eas_group_idxs |
eas_map_idxs |
eas_object_type_idxs |
eas_option_idxs |
eas_property_idxs |
eas_schedule_idxs |
eas_statistic_idxs |
Metadata
eas_column_map_insert |
eas_group_insert |
eas_object_type_insert |
eas_option_insert |
eas_option_type_insert |
eas_version_insert |
Tables
eas_collection_object |
eas_collection_sql |
eas_database |
eas_group |
eas_map |
eas_object_type |
eas_option |
eas_option_type |
eas_schedule |
eas_version |
ORACLE
Foreign Keys
eas_collection_fk1 |
eas_collection_fk2 |
eas_collection_object_fk1 |
eas_collection_object_fk2 |
eas_collection_sql_fk1 |
eas_filter_fk1 |
eas_filter_fk2 |
eas_map_fk1 |
eas_object_fk |
eas_option_fk1 |
eas_property_fk1 |
eas_property_fk2 |
eas_schedule_fk |
eas_statistic_fk2 |
eas_statistic_fk3 |
Indexes
eas_collection_fk1 |
eas_collection_fk2 |
eas_filter_fk1 |
eas_filter_fk2 |
eas_object_fk |
eas_object_uk |
eas_option_fk1 |
eas_property_fk1 |
eas_property_fk2 |
eas_schedule_fk |
eas_statistic_fk1 |
Metadata
eas_column_map_insert |
eas_object_type_insert |
eas_option_insert |
eas_option_type_insert |
eas_version_insert |
Tables
eas_collection |
eas_collection_object |
eas_collection_sql |
eas_database |
eas_filter |
eas_map |
eas_object |
eas_object_type |
eas_option |
eas_option_type |
eas_property |
eas_schedule |
eas_statistic |
eas_version |
Sybase ASE
Foreign Keys
eas_collection_fk1 |
eas_collection_fk2 |
eas_collection_object_fk1 |
eas_collection_object_fk2 |
eas_filter_fk1 |
eas_filter_fk2 |
eas_group_recfk |
eas_map_fk1 |
eas_object_fk |
eas_object_type_fk |
eas_option_fk1 |
eas_property_fk1 |
eas_property_fk2 |
eas_schedule_fk |
eas_statistic_fk1 |
eas_statistic_fk2 |
eas_statistic_fk3 |
Indexes
eas_collection_idxs |
eas_collection_object_idxs |
eas_filter_idxs |
eas_group_idxs |
eas_map_idxs |
eas_object_idxs |
eas_object_type_idxs |
eas_option_idxs |
eas_property_idxs |
eas_schedule_idxs |
eas_statistic_idxs |
Metadata
eas_column_map_insert |
eas_database_insert |
eas_group_insert |
eas_object_type_insert |
eas_option_insert |
eas_option_type_insert |
eas_version_insert |
Procedures
sp_embt_ca_check_syb_version |
sp_embt_ca_db_obj_space |
sp_embt_ca_dbspace |
sp_embt_ca_delete_collection |
sp_embt_ca_get_col_metric_info |
sp_embt_ca_get_metric_query_ex |
sp_embt_ca_get_purge_cond |
sp_embt_ca_get_purge_status |
sp_embt_ca_get_refresh_cond |
sp_embt_ca_get_refresh_status |
sp_embt_ca_is_admin |
sp_embt_ca_is_auto_purge_set |
sp_embt_ca_is_col_available |
sp_embt_ca_is_col_scheduled |
sp_embt_ca_is_filter_all_set |
sp_embt_ca_purge_data |
sp_embt_ca_run_collection |
sp_embt_ca_run_datastruct |
sp_embt_ca_set_col_status |
sp_embt_ca_upd_schedule_dates |
Table
eas_collection_object |
eas_collection_sql |
eas_database |
eas_group |
eas_map |
eas_object_type |
eas_option |
eas_option_type |
eas_schedule |
eas_version |