Question
1
Replies
126
Views
Infosys
Posted: May 14, 2019
Last activity: April 26, 2020
Solved
Pega-Engine Agents for DB Statistics and Blob sizing
Hi All,
The customer is using Pega 7.4 and I see the below agents are enabled in their production environment.
Pega-Engine
> Update PegaRULES database table statistics
> Update PegaDATA database table statistics
> Collect PegaRULES database blob size statistics
> Collect PegaDATA database blob size statistics
In the history tab, Pega-Engine activity mentions that these are useful for postgres database. My client uses MS SQL Server. I am trying to find out the purpose of these agents. Does anyone know? And, does it make sense to keep these running on MS SQL database? Let me know your thoughts.
Hi Tarun,
In Postgres, the statistics basically helps with the reporting about the database activity on tables and other components. This agent updates them on a regular basis.
If you are running on MS-SQL server, then you can go ahead and disable these agents.