Overview

This check monitors Vertica through the Datadog Agent.

Setup

Installation

The Vertica check is included in the Datadog Agent package. No additional installation is needed on your server.

Configuration

Edit the vertica.d/conf.yaml file, in the conf.d/ folder at the root of your Agent’s configuration directory to start collecting your vertica performance data. See the example vertica.d/conf.yaml for all available configuration options.

Enabling SSL

The Vertica integration supports connecting to Vertica through SSL. To enable this, set use_tls in conf.yaml to true.

Note: For Vertica integration versions <=1.9.0, set tls_verify to true instead. For legacy support, if tls_verify is explicitly set to true, use_tls is set to true.

Prepare Vertica

Create a database user for the Datadog Agent. From vsql, connect to the database as a superuser. Then run the CREATE USER statement.

CREATE USER datadog IDENTIFIED BY '<PASSWORD>';

The user used to connect to the database must be granted the SYSMONITOR role in order to access the monitoring system tables.

GRANT SYSMONITOR TO datadog WITH ADMIN OPTION;

As the metrics for current license usage use the values from the most recent audit, Datadog recommends scheduling audits to occur as often as possible. For more information, see the Vertica audit license guide.

Restart the Agent to start sending Vertica metrics to Datadog.

Log collection

Available for Agent versions >6.0

1. Collecting logs is disabled by default in the Datadog Agent, enable it in your datadog.yaml file:

   logs_enabled: true
   

2. Add this configuration block to your vertica.d/conf.yaml file to start collecting your Vertica logs:

   logs:
     - source: vertica
       type: file
       path: "/<CATALOG_PATH>/<DATABASE_NAME>/<NODE_NAME>_catalog/vertica.log"
       service: vertica
   

3. Restart the Agent.

Validation

Run the Agent’s status subcommand and look for vertica under the Checks section.

Data Collected

Metrics

Events

Vertica does not include any events.

Service Checks

vertica.can_connect
Returns OK if the Agent is able to connect to the monitored Vertica database, or CRITICAL otherwise.
Statuses: ok, critical

vertica.node_state
Returns OK for each node that is UP, WARNING for nodes that are on a possible path to UP, or CRITICAL otherwise.
Statuses: ok, warning, critical, unknown

Troubleshooting

Need help? Contact Datadog support.