BSM Profile Database growing very fast

  • KM01027771
  • 08-Jul-2014
  • 08-Jul-2014

Summary

BSM Profile Database growing very fast

Question

BSM Profile Database growing very fast at a rate of almost 8-10 GB everyday. Earlier, the growth was not this high.

Answer

Check the Profile DB and find out which table is taking up the highest space.

Found that M_KE01F1_F table is utilizing most of the DB space.

This table is mapped to bl_kpi_ot_ke table in the DB. It stores KPI overtime sample history for the CI’.
Check and confirm if Store KPI history option is enabled in the CI properties.
If history information is not required, disable it by going to Admin -> Service health -> CI indicator tab.