Reducing StatisticalInterface

The StatisticalInterface table stores data collected by the Interface Utilization performance monitor when enabled on a device.

There are several options to reduce the size of this table, listed in order of least impact to the monitoring system.

  1. Enable monitoring only for the important interfaces in your network.
    By default, WhatsUp Gold monitors all the active interfaces on every device that supports SNMP and has interfaces. An active interface is defined as an interface which is both enabled and has a link. This can include Windows workstations, connected but unused ports on switches, and other devices. You should collect interface utilization information from only those interfaces for which bandwidth availability is a concern. You can set WhatsUp Gold to poll only the specific interfaces you identify by configuring the Interface Utilization performance monitor on the device to only poll Specific interfaces. You can do this from the Device Properties - Performance Monitors dialog. Also, consider only monitoring interface utilization for one side of a connection. For example, if Port1 on SwitchA is connected to Port2 on SwitchB, monitoring interface utilization on both ports displays the same information, just in opposite directions. Monitoring interface utilization on both ports is redundant.
    You should also consider disabling data collection on workstations and servers whose interface speeds are greater than the switches to which they are connected. For example, a desktop workstation with a Gigabit interface that is connected to a 100Mbps switch will never reach capacity at the workstation side of the connection. Instead, monitor for interface utilization on the switch. For more information, see the Configure Interface Data Collection dialog help.
  2. Increase the polling interval for the Interface Utilization performance monitor on non-critical devices.
    By changing how often WhatsUp Gold collects data from devices, you can decrease the amount of storage needed in the database for the monitor's records. This can be done on a per-device basis from within the Device Properties - Performance Monitors dialog or for all devices using the Bulk Field Change feature. We recommend setting each device manually as this allows for separate intervals and will not change the collection type for the monitor on the device. For more information, see Configuring the Interface Utilization Monitor collection settings and the Bulk Field Change - Performance Monitor dialog help.

    Note: By setting a longer polling interval, you are decreasing the granularity of the performance monitor data on a device. For example, a device is set to collect utilization data every ten minutes for an hour. If there is a sustained period of 100% utilization for 10 minutes, while the rest of the hour shows 0% utilization, the period of 100% utilization is visible in the device's reports, followed by 0% utilization for the rest of the hour. But, if that same device is only collecting data once every 20 minutes, you only see 50% utilization of the interface during that 20-minute sample period.

  3. Change the data retention settings for all Performance Monitors configured in WhatsUp Gold.
    By default, WhatsUp Gold keeps raw performance monitor records for 1 day, hourly records for 30 days, and daily data for 1 year. Raw data is records in the database that contain actual values retrieved from a device during the poll of a performance monitor. This is the most granular data this table contains about performance monitor information on a device. Hourly records are an aggregate of an hour's worth of raw records, summarized and averaged into a single record. Instead of seeing each poll as a separate data point, the individual data points are reduced to a single, hourly summary. Daily records are a summarization of the 24 hourly records for that day. As time progresses, information in the database about a particular performance monitor gets less and less granular or specific until reaching the daily record expiration limit at which point the data is lost and replaced by new, incoming data. By adjusting the retention settings for performance monitor data, you can affect how much space is occupied by the StatisticalInterface table data. As you decrease the time period that records are kept, you decrease the amount of space needed to store those records.
    For information on changing data retention settings, see Changing how long report data is stored and the Program Options - Report Data dialog help.

Note: Changing these settings affects all the performance monitor data collected by WhatsUp Gold. This includes CPU, Disk, Memory, Ping Latency & Availability, Interface Utilization (collecting data for All Interfaces, Active Interfaces, Specific Interfaces, Custom Active Interfaces, and Interface Errors and Discards), Printer, VoIP, and any data collected by custom performance monitors you have created.

Tip: You can use the Alert Center to set database threshold alerts for WhatsUp Gold and Flow Monitor. For more information, see Configuring a WhatsUp Health threshold.