Question

3
Replies
45
Views
Close popover
Ponnurangam Nagaraj (PonnurangamN2827)
Vodafone

Vodafone
IN
PonnurangamN2827 Member since 2019 43 posts
Vodafone
Posted: August 11, 2019
Last activity: August 18, 2019
Closed

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
Moderation Team has archived post