Agent Check: Vertica

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

See metadata.csv for a list of metrics provided by this integration.

Events

Vertica does not include any events.

Service Checks

See service_checks.json for a list of service checks provided by this integration.

Troubleshooting

Need help? Contact Datadog support.