Increase in Production DB size due to to Session Logs

[PallaviMetkar]

we are using Blueprism 6.10.1
What is root cause of increasing session logs below is the screen shown.
what are best practices to avoid increasing session log so DB size will not be full.




------------------------------
Pallavi Metkar Senior Consultant
Consultant
capgemini
Indian/Antananarivo
------------------------------

[EmersonF]

Hi @PallaviMetkar There was already this discussion here on the forum, please see these topics, it will definitely help you.
good practices
#BPTechTips - Help with DB maintenance | Blue Prism Product
Suport
BP DB Maintenance Scripts | Blue Prism Product

If it was useful to you, mark as best answer
​​

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55 (081) 98886-9544
If my answer helped you? Mark as useful!
------------------------------

[EmersonF]

FYI - But basically, you can significantly reduce it just by activating the appropriate logs, I usually just activate the "Only Error" which is what interests me,
in debug mode too, go to options at all stages and select only error this should help a lot

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55 (081) 98886-9544
If my answer helped you? Mark as useful!
------------------------------

[JamesMan]

Yes, you absolutely need to put into place an archiving scheme of sorts to make sure that you keep the session logging tables under control. This can be done through the database, or by using the in-product session log archiving function.  The links that Emerson has provided should give you information on how to set up archiving.

------------------------------
James Man
Professional Services
Blue Prism
Asia/Hong_Kong
------------------------------