0 Replies Latest reply on Nov 27, 2019 10:51 AM by dpa1734

    Smart queries

    dpa1734

      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]