Question

3
Replies
53
Views
Ponnurangam Nagaraj (PonnurangamN2827)
Vodafone

Vodafone
IN
PonnurangamN2827 Member since 2019 43 posts
Vodafone
Posted: August 11, 2019
Last activity: August 18, 2019
Posted: 11 Aug 2019 16:40 EDT
Last activity: 18 Aug 2019 14:32 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.