This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Smart queries

Has someone compiled queries to run against the dpa_repository database for some insight into tuning metrics versus GUI option?

e.g. I researched these DPA tables and trying to decipher data !

[dpa_repository].[ignite].[CONST_9]

[dpa_repository].[ignite].[CONSPT_9]

[dpa_repository].[ignite].[CONSPA_9]

[dpa_repository].[ignite].[CONPR_9]

[dpa_repository].[ignite].[CONO_9]

[dpa_repository].[ignite].[CONM_9]

[dpa_repository].[ignite].[CONLOG]

[dpa_repository].[ignite].[CONF_9]

[dpa_repository].[ignite].[CONEXCLUDE_EVENTS]

[dpa_repository].[ignite].[CONEV_MAP_9]

[dpa_repository].[ignite].[CONEV_9]

[dpa_repository].[ignite].[COND]

[dpa_repository].[ignite].[CON_WAIT_CATEGORIES]

[dpa_repository].[ignite].[CON_SWIP_DATABASE_INFO]

[dpa_repository].[ignite].[CON_STATS_TEN_MINUTE_9]

[dpa_repository].[ignite].[CON_STATS_SUM_9]

[dpa_repository].[ignite].[CON_STATS_DAY_SUM_9]

[dpa_repository].[ignite].[CON_SQL_TEN_MINUTE_9]

[dpa_repository].[ignite].[CON_SQL_SUM_9]

[dpa_repository].[ignite].[CON_PROGRAM_TEN_MINUTE_9]

[dpa_repository].[ignite].[CON_PROGRAM_SUM_9]

[dpa_repository].[ignite].[CON_PROBLEM_SUMMARY_9]

[dpa_repository].[ignite].[CON_PROBLEM_DETAIL_9]

[dpa_repository].[ignite].[CON_PROBLEM_ANALYSIS_9]

[dpa_repository].[ignite].[CON_PLAN_TEN_MINUTE_9]

[dpa_repository].[ignite].[CON_PLAN_SUM_9]

[dpa_repository].[ignite].[CON_METRICS_NAMES_9]

[dpa_repository].[ignite].[CON_METRICS_HOUR_9]

[dpa_repository].[ignite].[CON_IO_HOUR_9]

[dpa_repository].[ignite].[CON_IO_DETAIL_9]

[dpa_repository].[ignite].[CON_IO_DAY_9]

[dpa_repository].[ignite].[CON_INDEX_ANALYSIS_9]

[dpa_repository].[ignite].[CON_IA_TABLE_SUMMARY_9]

[dpa_repository].[ignite].[CON_HASH_REFRESH]

[dpa_repository].[ignite].[CON_EVENTS]

[dpa_repository].[ignite].[CON_EVENT_SUM_9]

[dpa_repository].[ignite].[CON_DBUSER_TEN_MINUTE_9]

[dpa_repository].[ignite].[CON_DBUSER_SUM_9]

[dpa_repository].[ignite].[CON_CONTACT]

[dpa_repository].[ignite].[CON_ALERTABLE_EVENT]

[dpa_repository].[ignite].[CON_ALERT_HISTORY]

[dpa_repository].[ignite].[CON_ALERT_DB]

[dpa_repository].[ignite].[CON_AG_DATABASE]