Skip to Content

PI DB growing faster

Hi,

Our team BASIS consultant complained about rapid increase in production PI DB in the last 2-3 weeks. I checked in Message monitoring section, there wasn't any unwanted interface running and all interfaces are functioning as usual. I did a change in persistence of audit logs like, the audit log was not showing for messages that are older than 1 day, where i changed the parameter "messaging.auditLog.memoryCache = false". But this change was did 2 months before.

Could you please guide me on this. What are the PI tables that are to be monitored when this kind of scenario occurs. And what precautionary steps has to be taken to avoid rapid DB growth.

PI version: PI 7.5 Single Stack SP 10

Jens Schwendemann Ryan Crosby

Add a comment
10|10000 characters needed characters exceeded

  • I don't think it is wise to particularly "mention" people within your OP just to gather additional attention of those people. You may easily pick the wrong people (see Ryan's answer that he is not a basis guy) which may (and will ultimately) put people off

Assigned Tags

Related questions

2 Answers

  • Posted on Aug 26 at 06:18 PM

    Hi Subin.

    You may have to define the policy to keep the database of 3 to 4 weeks time remaining all the data can be archived or delete from the DB, so that you can manage the disk space. refer the sap note 2592310 and follow the SAP wiki link https://wiki.scn.sap.com/wiki/display/XI/PI+database+size+is+growing+large+SXMSCLUP%2C+SXMSCLUR

    Regards

    SS

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 26 at 07:38 PM

    Hi Subin,

    I am a developer so I cannot speak to items that fall within the BASIS realm. System and application configuration related to the database and persistence within the database should be understood well and handled by that team.

    Regards,

    Ryan Crosby

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Subin,

      I am not familiar with the parameter but it sounds like you may have disabled the use of memory cache for storage (which is what we have) and possibly diverted the information into the database on account of what you are experiencing. Your BASIS team should be able to confirm or find out what the purpose of that parameter is for and determine if that is what is causing the DB growth.

      Regards,

      Ryan Crosby

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.