KB 002 – Table BNWVS MTR is growing rapidly

Table /BNWVS/MTR is growing rapidly in the database

Symptom:

Table /BNWVS/MTR is growing continuously and getting very large.

Symptom: Table /BNWVS/MTR is growing continuously and getting very large

Cause:

This table contains the metric data to be collected by SAP PowerConnectand is purged according to the retention setting. If it is not sent it is held until the end of the retention period.

  • Unsent data is retained until the UNSENT retention period expires then it is deleted even if it is
    not sent, this ensure that the table can never grow too large.

This can be set in the SAP PowerConnect Control Panel -> Administrator -> Global Configuration.

This can be set in the SAP PowerConnect Control Panel -> Administrator -> Global Configuration.

Via the ARCHIVE_DAYS_TO_RETAIN_UNSENT setting. This controls the minimum retention for SENT metrics.

Via the ARCHIVE_DAYS_TO_RETAIN_UNSENT setting. This controls the minimum retention for SENT metrics.

  • Sent data is retained until the end of the Days to retain setting.

Sent data is retained until the end of the Days to retain setting.

This can be set in the SAP PowerConnect Control Panel -> Administrator -> Global Configuration.

This can be set in the  SAP PowerConnect Control Panel  - > Administrator  - > Global Configuration

Via the ARCHIVE_DAYS_TO_RETAIN setting. This controls the minimum retention for SENT metrics.

Via the ARCHIVE_DAYS_TO_RETAIN setting. This controls the minimum retention for  SENT metrics.

Download PDF version here