config.tableMonitor table

Edit online

The config.tableMonitor table stores data that is used to monitor the raw and historical poll data tables in the NCPOLLDATA database.

The following table describes the columns in the config.tableMonitor table.

Table 1. config.tableMonitor database table
Column name	Constraints	Data type	Description
MAXPOLLDATARATE	NOT NULL	LONG64	Defines the maximum insertion rate to the raw poll data table NCPOLLDATA.polldata in units of rows of data per hour. By default, this value is 20,000,000 (20 million) rows per hour.
MAXDAILYDATAAGE	NOT NULL	LONG64	Defines the maximum age, in hours, for the data in the daily summary poll data table NCPOLLDATA.pdEwmaForDay. Data in this table is capped at 24 hours. If the age of data in this table exceeds the limit in the MAXDAILYDATAAGE field, then the Polling engine, ncp_poller logs a message and issues an alert. By default, this value is 25.
MAXWEEKLYDATAAGE	NOT NULL	LONG64	Defines the maximum age, in days, for the data in the daily summary poll data table NCPOLLDATA.pdEwmaForWeek. Data in this table is capped at 7 days. If the age of data in this table exceeds the limit in the MAXWEEKLYDATAAGE field, then the Polling engine, ncp_poller logs a message and issues an alert. By default, this value is 8.
MAXMONTHLYDATAAGE	NOT NULL	LONG64	Defines the maximum age, in days, for the data in the daily summary poll data table NCPOLLDATA.pdEwmaForMonth. Data in this table is capped at 30 days. If the age of data in this table exceeds the limit in the MAXMONTHLYDATAAGE field, then the Polling engine, ncp_poller logs a message and issues an alert. By default, this value is 32.
MAXYEARLYDATAAGE	NOT NULL	LONG64	Defines the maximum age, in days, for the data in the daily summary poll data table NCPOLLDATA.pdEwmaForYear. Data in this table is capped at 365 days. If the age of data in this table exceeds the limit in the MAXYEARLYDATAAGE field, then the Polling engine, ncp_poller logs a message and issues an alert. By default, this value is 395.