Vertica

Supported OS Linux Mac OS Windows

Présentation

Ce check permet de surveiller Vertica avec l’Agent Datadog.

Configuration

Installation

Le check Vertica est inclus avec le package de l’Agent Datadog. Vous n’avez donc rien d’autre à installer sur votre serveur.

Configuration

Modifiez le fichier vertica.d/conf.yaml dans le dossier conf.d/ à la racine du répertoire de configuration de votre Agent pour commencer à recueillir vos données de performance Vertica. Consultez le fichier d’exemple vertica.d/conf.yaml pour découvrir toutes les options de configuration disponibles.

Activation de l’authentification SSL

L’intégration Vertica prend en charge les connexions SSL vers Vertica. Pour activer cette fonctionnalité, définissez use_tls sur true dans le fichier conf.yaml.

Remarque : pour la version 1.9.0 ou les versions antérieures de l’intégration Vertica, définissez plutôt tls_verify sur true. Pour l’ancienne configuration, si tls_verify est explicitement défini sur true, alors use_tls est défini sur true.

Préparer Vertica

Créez un utilisateur de base de données pour l’Agent Datadog. Depuis vsql, connectez-vous à la base de données en tant que super-utilisateur. Exécutez ensuite la déclaration CREATE USER.

CREATE USER datadog IDENTIFIED BY '<MOTDEPASSE>';

Le rôle SYSMONITOR doit être octroyé à l’utilisateur se connectant à la base de données pour qu’il puisse accéder aux tables système de surveillance.

GRANT SYSMONITOR TO datadog WITH ADMIN OPTION;

En outre, comme les métriques relatives à l’utilisation actuelle des licences utilisent les valeurs provenant du dernier audit, Datadog recommande d’effectuer des audits aussi fréquemment que possible. Pour en savoir plus, consultez le guide relatif aux licences d’audit Vertica (en anglais).

Redémarrez l’Agent pour commencer à envoyer des métriques Vertica à Datadog.

Collecte de logs

Disponible à partir des versions > 6.0 de l’Agent

  1. La collecte de logs est désactivée par défaut dans l’Agent Datadog. Vous devez l’activer dans datadog.yaml :

    logs_enabled: true
    
  2. Ajoutez ce bloc de configuration à votre fichier vertica.d/conf.yaml pour commencer à recueillir vos logs Vertica :

    logs:
      - source: vertica
        type: file
        path: "/<CATALOG_PATH>/<DATABASE_NAME>/<NODE_NAME>_catalog/vertica.log"
        service: vertica
    
  3. Redémarrez l’Agent.

Validation

Lancez la sous-commande status de l’Agent et cherchez vertica dans la section Checks.

Données collectées

Métriques

vertica.connection.active
(gauge)
The current number of connections to a node.
Shown as connection
vertica.connection.total
(count)
The total number of connections to a node.
Shown as connection
vertica.delete_vectors
(gauge)
The total number of delete vectors.
Shown as item
vertica.disk.used
(gauge)
The total disk space (compressed) used in bytes.
Shown as byte
vertica.disk.used.ros
(gauge)
[Only versions <= 10] The total ROS disk space (compressed) used in bytes.
Shown as byte
vertica.disk.used.wos
(gauge)
[Only versions <= 10] The total WOS disk space (compressed) used in bytes.
Shown as byte
vertica.epoch.ahm
(gauge)
The current epoch number.
Shown as time
vertica.epoch.current
(gauge)
The AHM epoch number.
Shown as time
vertica.epoch.last_good
(gauge)
The smallest (min) of all the checkpoint epochs on the cluster.
Shown as time
vertica.file.max
(gauge)
The maximum number of files that can be open at one time.
Shown as file
vertica.file.open
(gauge)
The number of open files.
Shown as file
vertica.ksafety.current
(gauge)
The number of node failures the cluster can tolerate before it shuts down automatically.
Shown as node
vertica.ksafety.intended
(gauge)
The designed or intended K-safety level.
Shown as node
vertica.license.expiration
(gauge)
The time until license expiration.
Shown as second
vertica.license.latest_audit
(gauge)
The time elapsed since the latest license audit was triggered.
Shown as second
vertica.license.size
(gauge)
The total size of the license in bytes.
Shown as byte
vertica.license.usable
(gauge)
The total usable size of the license in bytes.
Shown as byte
vertica.license.used
(gauge)
The total used size of the license in bytes.
Shown as byte
vertica.license.utilized
(gauge)
The utilization of the license as a percentage.
Shown as percent
vertica.memory.swap.total
(gauge)
The total amount of swap memory in bytes.
Shown as byte
vertica.memory.swap.usable
(gauge)
The total usable amount of swap memory in bytes.
Shown as byte
vertica.memory.swap.used
(gauge)
The total used amount of swap memory in bytes.
Shown as byte
vertica.memory.swap.utilized
(gauge)
The utilization of swap memory as a percentage.
Shown as percent
vertica.memory.total
(gauge)
The total amount of physical RAM in bytes.
Shown as byte
vertica.memory.usable
(gauge)
The total usable amount of physical RAM in bytes.
Shown as byte
vertica.memory.used
(gauge)
The total used amount of physical RAM in bytes.
Shown as byte
vertica.memory.utilized
(gauge)
The utilization of physical RAM as a percentage.
Shown as percent
vertica.node.allowed
(gauge)
The number of nodes permitted for use by the license.
Shown as node
vertica.node.available
(gauge)
The number of available nodes remaining based on the license limit.
Shown as node
vertica.node.delete_vectors
(gauge)
The number of delete vectors in nodes.
Shown as item
vertica.node.disk.used
(gauge)
The total disk space used by nodes in bytes.
Shown as byte
vertica.node.disk.used.ros
(gauge)
[Only versions <= 10] The ROS disk space used by nodes in bytes.
Shown as byte
vertica.node.disk.used.wos
(gauge)
[Only versions <= 10] The WOS disk space used by nodes in bytes.
Shown as byte
vertica.node.down
(gauge)
The number of nodes that are currently down.
Shown as node
vertica.node.resource_requests
(gauge)
The cumulative number of requests for threads, file handles, and memory (in kilobytes).
Shown as resource
vertica.node.ros.containers
(gauge)
The number of ROS containers in nodes.
Shown as resource
vertica.node.row.ros
(gauge)
[Only versions <= 10] The number of ROS rows in nodes.
Shown as row
vertica.node.row.total
(gauge)
The total number of rows in nodes.
Shown as row
vertica.node.row.wos
(gauge)
[Only versions <= 10] The number of WOS rows in nodes.
Shown as row
vertica.node.total
(gauge)
The number of nodes currently in use.
Shown as node
vertica.processor.core
(gauge)
The number of processor cores in the system.
Shown as core
vertica.processor.cpu
(gauge)
The number of system processors.
Shown as cpu
vertica.projection.delete_vectors
(gauge)
The number of delete vectors in projections.
Shown as item
vertica.projection.disk.used
(gauge)
The total disk space used by projections in bytes.
Shown as byte
vertica.projection.disk.used.ros
(gauge)
[Only versions <= 10] The ROS disk space used by projections in bytes.
Shown as byte
vertica.projection.disk.used.wos
(gauge)
[Only versions <= 10] The WOS disk space used by projections in bytes.
Shown as byte
vertica.projection.ros.containers
(gauge)
The number of ROS containers in projections.
Shown as resource
vertica.projection.row.ros
(gauge)
[Only versions <= 10] The number of ROS rows in projections.
Shown as row
vertica.projection.row.total
(gauge)
The total number of rows in projections.
Shown as row
vertica.projection.row.wos
(gauge)
[Only versions <= 10] The number of WOS rows in projections.
Shown as row
vertica.projection.total
(gauge)
The total number of projections.
Shown as table
vertica.projection.unsafe
(gauge)
The number of projections that are not up to date.
Shown as table
vertica.projection.unsafe_percent
(gauge)
The percentage of projections that are not up to date.
Shown as percent
vertica.projection.unsegmented
(gauge)
The number of projections that are not segmented.
Shown as table
vertica.projection.unsegmented_percent
(gauge)
The percentage of projections that are not segmented.
Shown as percent
vertica.query.active
(gauge)
The current number of queries running on a node.
Shown as query
vertica.query.total
(count)
The total number of queries executed on a node.
Shown as query
vertica.resource_pool.memory.borrowed
(gauge)
The amount of memory borrowed from the GENERAL pool by requests running against pools.
Shown as byte
vertica.resource_pool.memory.max
(gauge)
The value of the MAXMEMORYSIZE parameter as defined for pools.
Shown as byte
vertica.resource_pool.memory.used
(gauge)
The amount of memory acquired by requests running against pools.
Shown as byte
vertica.resource_pool.query.running
(gauge)
The number of queries currently executing in pools.
Shown as query
vertica.ros.containers
(gauge)
The total number of ROS containers.
Shown as resource
vertica.row.ros
(gauge)
[Only versions <= 10] The total number of ROS rows.
Shown as row
vertica.row.total
(gauge)
The total number of rows.
Shown as row
vertica.row.wos
(gauge)
[Only versions <= 10] The total number of WOS rows.
Shown as row
vertica.socket.open
(gauge)
The number of open sockets.
Shown as file
vertica.storage.latency
(gauge)
The latency of a storage location in seeks per second.
Shown as read
vertica.storage.size
(gauge)
The total size of a storage location in bytes.
Shown as byte
vertica.storage.speed
(gauge)
The time (in seconds) it takes to read 1 mebibyte from a storage location.
Shown as second
vertica.storage.throughput
(gauge)
The throughput of a storage location in mebibytes per second.
Shown as mebibyte
vertica.storage.usable
(gauge)
The total usable size of a storage location in bytes.
Shown as byte
vertica.storage.used
(gauge)
The total used size of a storage location in bytes.
Shown as byte
vertica.storage.utilized
(gauge)
The utilization of a storage location as a percentage.
Shown as percent
vertica.table.disk.used
(gauge)
The total disk space used by tables in bytes.
Shown as byte
vertica.table.disk.used.ros
(gauge)
[Only versions <= 10] The ROS disk space used by tables in bytes.
Shown as byte
vertica.table.disk.used.wos
(gauge)
[Only versions <= 10] The WOS disk space used by tables in bytes.
Shown as byte
vertica.table.ros.containers
(gauge)
The number of ROS containers in tables.
Shown as resource
vertica.table.row.ros
(gauge)
[Only versions <= 10] The number of ROS rows in tables.
Shown as row
vertica.table.row.total
(gauge)
The total number of rows in tables.
Shown as row
vertica.table.row.wos
(gauge)
[Only versions <= 10] The number of WOS rows in tables.
Shown as row
vertica.thread.active
(gauge)
The number of active threads.
Shown as thread
vertica.thread.max
(gauge)
The maximum number of threads that can coexist.
Shown as thread

Checks de service

vertica.can_connect :
Renvoie OK si l’Agent parvient à se connecter à la base de données Vertica qu’il surveille. Si ce n’est pas le cas, renvoie CRITICAL.

vertica.node_state :
Renvoie OK pour les nœuds disponibles, WARNING pour ceux qui semblent être sur le point de devenir disponibles et CRITICAL pour les autres cas.

Événements

Vertica n’inclut aucun événement.

Dépannage

Besoin d’aide ? Contactez l’assistance Datadog.

PREVIEWING: alai97/reorganize-some-sections-in-dora-metrics