Teradata インテグレーションのメトリクス

Teradata の監視に使う Datadog の公式インテグレーションです。収集するメトリクスは 78 件あります。

公式の紹介文 (英語)

Monitor the health and performance of your Teradata Vantage Database.

種別の内訳

  • gauge (その時点の値): 78 件

メトリクスの一覧

説明は公式の定義の英文をそのまま載せています。

メトリクス種別単位
teradata.amp.cpu_timeNumber of seconds of AMP insert CPU time used by the user and accountgaugesecond
teradata.amp.cpu_time_normNormalized AMP CPU time used by the user and accountgaugesecond
teradata.amp.disk_ioTotal number of reads and writes to disk by each AMP in the systemgauge-
teradata.db_lock.blocksNumber of times a database lock was blockedgauge-
teradata.db_lock.deadlocksNumber of times a database lock was deadlockedgauge-
teradata.disk_space.alloc_permCurrent total allocation in bytes for permanent and user defined temporary table space. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.alloc_perm.totalCurrent total allocation in bytes for permanent and user defined temporary table space. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.alloc_spoolCurrent total allocation in bytes for spool and other system defined temporary table space. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.alloc_spool.totalCurrent total allocation in bytes for spool and other system defined temporary table space. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.alloc_tempCurrent total allocation in bytes for temporary tables space. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.alloc_temp.totalCurrent total allocation in bytes for temporary tables space. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.curr_permPermanent space per AMP currently being used. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.curr_perm.totalPermanent space per AMP currently being used. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.curr_persist_spoolPersistent spool space per AMP currently being used by the user. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.curr_persist_spool.totalPersistent spool space per AMP currently being used by the user. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.curr_spoolSpool space per AMP currently being used by the user. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.curr_spool.totalSpool space per AMP currently being used by the user. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.curr_tempThe number of bytes currently used by a temporary table per virtual processor (vproc). Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.curr_temp.totalThe number of bytes currently used by a temporary table per virtual processor (vproc). Database level metric tagged by td_database.gaugebyte
teradata.disk_space.max_permMaximum permanent space, in bytes, that is allocated to the database on a specified AMP. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.max_perm.totalMaximum permanent space, in bytes, that is allocated to the database on a specified AMP. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.max_prof_spoolThe profile SPOOL space limit per AMP for the user if the user is assigned a profile which has a SPOOL space setting. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.max_prof_spool.totalThe profile SPOOL space limit per AMP for the user if the user is assigned a profile which has a SPOOL space setting. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.max_prof_tempThe profile TEMPORARY space limit per AMP for the user if the user is assigned a profile which has a TEMPORARY space setting. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.max_prof_temp.totalThe profile TEMPORARY space limit per AMP for the user if the user is assigned a profile which has a TEMPORARY space setting. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.max_spoolMaximum spool space, in bytes, that is allocated to the database on a specified AMP. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.max_spool.totalMaximum spool space, in bytes, that is allocated to the database on a specified AMP. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.max_tempMaximum temporary space, in bytes, that is allocated to the database on a specified AMP. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.max_temp.totalMaximum temporary space, in bytes, that is allocated to the database on a specified AMP. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.peak_permMaximum amount of permanent space per AMP that has been used by the database since the last time the DBC.ClearPeakDisk macro was run. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.peak_perm.totalMaximum amount of permanent space per AMP that has been used by the database since the last time the DBC.ClearPeakDisk macro was run. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.peak_persist_spoolMaximum persistent spool space, in bytes, that was used at any one time by the database on a specified AMP. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.peak_persist_spool.totalMaximum persistent spool space, in bytes, that was used at any one time by the database on a specified AMP. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.peak_spoolMaximum spool space, in bytes, that was used at any one time by the database on a specified AMP. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.peak_spool.totalMaximum spool space, in bytes, that was used at any one time by the database on a specified AMP. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.peak_tempPeak number of bytes used at one time by a temporary table per vproc. Table level metric tagged by td_table and td_database.gaugebyte
teradata.disk_space.peak_temp.totalPeak number of bytes used at one time by a temporary table per vproc. Database level metric tagged by td_database.gaugebyte
teradata.disk_space.perm_skewPermissible skew limit percent for permanent space usage at the AMP level. Table level metric tagged by td_table and td_database.gauge/percent
teradata.disk_space.perm_skew.totalPermissible skew limit percent for permanent space usage at the AMP level. Database level metric tagged by td_database.gauge/percent
teradata.disk_space.spool_skewPermissible skew limit percent for spool space usage at the AMP level. Table level metric tagged by td_table and td_database.gauge/percent
teradata.disk_space.spool_skew.totalPermissible skew limit percent for spool space usage at the AMP level. Database level metric tagged by td_database.gauge/percent
teradata.disk_space.temp_skewPermissible skew limit percent for temporary space usage at the AMP level. Table level metric tagged by td_table and td_database.gauge/percent
teradata.disk_space.temp_skew.totalPermissible skew limit percent for temporary space usage at the AMP level. Database level metric tagged by td_database.gauge/percent
teradata.file_lock.blocksNumber of lock requests that were blockedgauge-
teradata.file_lock.deadlocksNumber of deadlocks detected on lock requestsgauge-
teradata.file_lock.entersNumber of times a lock was requestedgauge-
teradata.io.throttle_countNumber of times an I/O was throttledgauge-
teradata.io.throttle_timeTotal I/O Throttle Time in millisecondsgaugemillisecond
teradata.io.throttle_time_maxMaximum I/O Throttle Time in millisecondsgaugemillisecond
teradata.mem.ctxt_page_readsNumber of pages swapped ingaugepage
teradata.mem.ctxt_page_writesNumber of pages swapped outgaugepage
teradata.mem.fsg.cache_sizeAllocated memory for FSG cache. This includes the memory allocated for TIM (VHCacheKB)gaugekilobyte
teradata.mem.kernel_inuse_sizeAmount of Kernel memory in use by PDE in kilobytesgaugekilobyte
teradata.mem.page_faults_majorNumber of major page faults. If the page is not loaded in memory at the time the fault is generated, then it is called a major or hard page faultgaugepage
teradata.mem.page_faults_minorNumber of minor page faults. If the page is loaded in memory at the time the fault is generated, but is not marked in the memory management unit as being loaded in memory, then it is called a minor or soft page fault.gaugepage
teradata.mem.seg_cache_sizeCurrent MB of segment cachegaugemegabyte
teradata.mem.seg_in_use_sizeCurrent MB of PDE segment files in usegaugemegabyte
teradata.mem.seg_max_avail_sizeCurrent MB of maximum PDE segment files availablegaugemegabyte
teradata.mem.seg_mdl.allocNumber of segments of all sizes allocated for the MDL pool during this periodgauge-
teradata.mem.seg_mdl.alloc_sizeKB of segments of all sizes allocated for the MDL pool during this periodgaugekilobyte
teradata.mem.seg_mdl.freeNumber of dirty segments of all sizes freed from the MDL pool during this periodgauge-
teradata.mem.seg_mdl.free_sizeKB of dirty segments of all sizes freed from the MDL pool during this periodgaugekilobyte
teradata.mem.seg_mdl.inuse_sizeTotal memory in use by segment MDLsgaugekilobyte
teradata.mem.seg_mdl.recycleNumber of segments of all sizes recycled to the MDL pool during this periodgauge-
teradata.mem.seg_mdl.recycle_sizeKB of segments of all sizes recycled to the MDL pool during this periodgaugekilobyte
teradata.mem.seg_mdl.releaseNumber of clean segments of all sizes freed from the MDL pool during this periodgauge-
teradata.mem.seg_mdl.release_sizeKB of clean segments of all sizes freed from the MDL pool during this periodgaugekilobyte
teradata.mem.txt_page_readsNumber of pages paged minus the pages swapped ingaugepage
teradata.mem.vh_cache_sizeCurrent size of the VH cache in KB. This field is populated by theFSG subsystemgaugekilobyte
teradata.process.blockedNumber of threads blocked waiting for I/O at the current timegaugethread
teradata.process.cpu_execTime in milliseconds CPUs are busy executing user execution code, that is, time spent in a user state on behalf of a process. CPUUExec reports the CPU time not used in the system call, or in the kernelgaugemillisecond
teradata.process.cpu_idleTime in milliseconds CPUs are idle and not waiting for I/Ogaugemillisecond
teradata.process.cpu_io_waitTime in milliseconds CPUs are idle and waiting for I/O completiongaugemillisecond
teradata.process.cpu_servTime in milliseconds CPUs are busy executing user service code, that is, privileged work performing system services on behalf of user execution processes which do not have root access CPUUServ reports if a task executing a step used CPU while in the kernelgaugemillisecond
teradata.process.cpu_throttleNumber of times that WM CPU COD throttling was triggeredgauge-
teradata.process.cpu_throttle_timeTime in milliseconds that WM CPU COD throttling was activegaugemillisecond
teradata.process.readyNumber of runnable or ready tasks, also called threads, able to execute on CPUs when a CPU becomes availablegaugethread
teradata.process.ready_maxMaximum number of ready tasks, also called threads, able to execute on CPUs when a CPU becomes availablegaugethread

公式ドキュメント

Teradata インテグレーションの公式ドキュメント

メトリクスの名前と説明は Datadog の公式インテグレーションの定義 (Copyright Datadog, Inc.・BSD-3-Clause) を英文のまま載せています。利用条件の全文は サイトについてにあります。