Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Tarun Kumar Reddy Bolla (Tarun Bolla)
IKOR PX
Lead System Architect
IKOR PX
AU
Tarun Bolla Member since 2010 23 posts
IKOR PX
Posted: May 14, 2019
Last activity: Apr 26, 2020
Posted: 14 May 2019 1:45 EDT
Last activity: 26 Apr 2020 19:44 EDT
Closed
Solved

Pega-EngineAgents 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.

To see attachments, please log in.
Java and Activities
Data Integration

Accepted Solution

Posted: 5 years ago
Updated: 4 years ago
Posted: 8 Jun 2019 7:55 EDT
Updated: 26 Apr 2020 19:44 EDT
Ajay Rangarh (Ajay_Rangarh)
Instellars
Consultant
Instellars
IN

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.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice