Regarding Production Issue in memory management

[SachinBais]

Hello All, i am facing issue related to memory management with SQL Server in Production. my process include queue and approx 8000 data in excel However running the process for two days had filled the database with around 140 GB. How can we clear the database and do we handle such scenario ?

[John__Carter]

The main data a process adds to a DB is via the work queue and the logs, and both are under your control. http://portal.blueprism.com/system/files/2018-03/Logging%20Best%20Practices%20Guide.pdf http://portal.blueprism.com/system/files/2018-03/Logging%20Configuration%20Policy%20Template.pdf http://portal.blueprism.com/system/files/2018-01/Blue%20Prism%20-%20Development%20Best%20Practice.pdf http://portal.blueprism.com/system/files/2017-09/Archive%20and%20Backup%20Policy.zip