Question
1
Replies
112
Views
Infosys
Posted: 1 year ago
Last activity: 4 months 3 weeks ago
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.
Accepted Solution
Posted: 1 year ago
Updated: 4 months ago
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.