BP Process Log size

[Prabhakara_Kuma]

Some of the process logs are clogging the database in production environment and it is becoming painful job to clean up those logs for creating DB space. We are looking for a way to get statistics around log size of each process execution to identify processes contributing to this issue.  Are there any DB (log) queries (SQL) available to find the log data size at the process level?

[John__Carter]

Logs will almost always form the bulk of a BP DB and it's vital to have logging and archiving policies to control DB growth. Ideally you want to arrive at a logging level that provides a level of audit but not so much that storage becomes a burden. It's also a good idea to avoid very long running sessions (>24h) so as not to create huge individual session logs that become difficult to archive. Logs are grouped by session, and sessions are recorded in the BPASession table. https://portal.blueprism.com/documents/logging-best-practice https://portal.blueprism.com/documents/logging-configuration-policy-template https://portal.blueprism.com/documents/archive-and-backup-policy