Data Collector

A utility that collects and retains database monitoring information.

Note: Data Collector works in conjunction with an advisor tool called Workload Analyzer, which intelligently monitors the performance of SQL queries and workloads and recommends tuning actions based on observations of the actual workload history.

Data Collector retains history of important system activities and records essential performance and resource utilization counters. You can use information the Data Collector retains in the following ways:

As a reference for what actions users have taken
To locate performance bottlenecks
To identify potential improvements to Vertica configuration

Data Collector is on by default. If you need to change this behavior, see Data Collector Parameters in the Administrator's Guide. See also the SQL Reference Manual for information about data collection control functions.