Question

4
Replies
62
Views
ChaithuLBG Member since 2014 6 posts
LLoyds Banking Group
Posted: 2 years ago
Last activity: 2 years 1 month ago
Closed

Expensive Query in Pega 7.3.1

Hi All-

We are running a Pega Upgrade project in our enterprise and as part of it, performance and Capacity team reported that the below query has been triggered continuously.

INSERT

INTO PEGDEVR0.pr_sys_appcache_dep(pzInsKey, pxCommitDateTime,

"PXCREATEDATETIME", "PXCREATEOPERATOR", "PXCREATEOPNAME",

"PXCREATESYSTEMID", "PXINSNAME", "PXOBJCLASS",

"PXSAVEDATETIME", "PZAPPLIESTOCLASSNAME",

"PZASSEMBLYTIMECLASS", "PZCACHECONFIGID", "PZCLASS",

"PZCLASSHASH", "PZDEPENDENCYKEY", "PZDEPRULEINSID",

"PZDEPRULEINSKEY", "PZEXCLUDEFROMAA",

"PZEXPLICITEXCLUDECOMBINED", "PZEXPLICITINLINECLASS",

"PZIMPLEMENTATIONKEY", "PZMODELINDEX", "PZPACKAGE",

"PZRULENAME", "PZRULESETNAME", "PZRULESETVERSIONMAJOR",

"PZRULESETVERSIONMINOR", "PZRULESETVERSIONPATCH",

"PZRULETYPE")

VALUES (?, CURRENT_TIMESTAMP, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?

, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Do we know as part of which Pega activity , this query is getting triggered and can we stop this ?

System Administration
Moderation Team has archived post
Share this page LinkedIn