cancel
Showing results for 
Search instead for 
Did you mean: 
dpa1734
Level 7

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]

0 Kudos