Question

3
Replies
34
Views
X
PonnurangamN2827 Member since 2019 40 posts
Vodafone
Posted: 10 months ago
Last activity: 10 months 3 weeks ago

PushLogusagedata causing performance issue

We have observed pushlogusagedata causing lot of pega0005 alerts in alert log during campaign and inbound requests span which is causing performance issue in DB.

Our application is using pega version 7.3.1 and AES 7.30.

Pushlogusagedata is running every 600sec .

1.what would happen if run this agent once per day during non-business office hour?

2.Do i have to customize the PusgLogUsagetoAES in this case?

3. will it improve the query performance if i create one more index on column 'pxRequestorType'?

Query : SELECT TO_CHAR(TRUNC("PC0"."PXSNAPSHOTTIME",'DD'),'YYYYMMDD') AS "pyDateValue(1)" , "PC0"."PXREQUESTORTYPE" AS "pxRequestorType" , COUNT(DISTINCT "PC0"."PXREQUESTORID") AS "pySummaryCount(1)" , COUNT(DISTINCT "PC0"."PYUSERIDENTIFIER") AS "pySummaryCount(2)" FROM PEGADATA.pr_perf_stats "PC0" WHERE ( "PC0"."PXSYSTEMNODEID" = ? AND "PC0"."PXSNAPSHOTTIME" >= ? AND "PC0"."PXSNAPSHOTTIME" < ? ) AND "PC0"."PXOBJCLASS" = ? GROUP BY TO_CHAR(TRUNC("PC0"."PXSNAPSHOTTIME",'DD'),'YYYYMMDD') , "PC0"."PXREQUESTORTYPE" ORDER BY 1 DESC, 2 ASC

Please suggest

***Moderator Edit-Vidyaranjan: Updated Platform Capability***

Data Integration System Administration
Share this page LinkedIn