Question

5
Replies
713
Views
MITTS Member since 2011 14 posts
PEGA
Posted: August 11, 2016
Last activity: September 6, 2016
Closed

Advice on reducing size of database tables

Our development database size currently seems to be exceeding 20GB and customer have asked us to provide some inputs on expected database size/capacity to control backups/disk space etc..

Out of the 20 GB,

               13-14 GB seems to be Rules data

               2-3 GB is application data

               3-5 GB seems to be other system data tables like pr_perf_stats, pr_sys_statusdetail

I have attached an excel showing top system tables occupying space in our database

Platform – 7.1.8 with Customer Services 7.1.3

Is there a guidance document available somewhere which I can refer to understand the expected

  • Rules/system data tables growth w.r.t application data
  • What can be turned off w/o impacting application to reduce size of rules/system data tables
  • Some other literate which can aid understanding and knowledge in this area 

***Updated by Moderator: Marissa. Removed user added Ask the Expert and FAQ tags. Apologies for confusion, shouldn't have been an end-user option***

Data Integration
Moderation Team has archived post
Share this page LinkedIn