BPASessionLog_NonUnicode

[pavelzuravliov]

Hello, In DB table BPASessionLog_NonUnicode is the biggest one (7 GB) can we clean it up or just delete some data?

[John__Carter]

Sessions logs and queues normally account for most of the DB size, however I would not recommend deleting data via SQL because you might damage the DB. Use the Archive function in the BP client.

[AMITJAGTAP1]

We are getting same issue as ""database size is full and need to delete some space for ""BPAsessionlog_nonunicode"""". We are deleting logs from BP client archiving function regularly. Is there any other resolution for this issues. Its hammering the data logs and reports. Previously we used to keep logs around 10 days but now within 4 days its throwing disk full massage. below is the actual massage: Number of rows of table [PRD_BP_DBTWO].[dbo].[BPASessionLog_NonUnicode] higher than 100000000 (436184847)

[ryanamiller]

You can also go through processes and disable logging for steps in order to reduce the log sizes for each execution