Sizing considerations

The polling load on a server can be expressed by calculating the overall polling insert rate to the NCPOLLDATA database. The higher the insert rate, the larger the capacity needed within the raw and historical poll data storage tables to store the poll data. Once the historical poll data tables increase beyond a certain size, the performance of queries to the tables by dashboards and reports is likely to degrade; therefore both the insert rate to the POLLDATA raw poll data table, and the total number of rows in the historical poll data tables must not be increased beyond a recommended limits in order to ensure system stability.

It is recommended that the polling insert rate to the POLLDATA raw data table should not exceed 20 million inserts per hour, and the total number of rows for the aggregate data tables should not exceed 200 million rows. This ensures that the size of each of the historical polling data tables stays within acceptable limits.