Question

3
Replies
48
Views
Close popover
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 216 posts
Anthem
Posted: March 15, 2021
Last activity: March 28, 2021

pr_sys_serviceregistry related PEGA0005 Alerts.

Hi Team,

We have upgraded recently to PRPC842 version and below mentioned SQL queries related to pr_sys_serviceregistry table haven been observed to be impacting the performance of application.

To start with, what does this pr_sys_serviceregistry do ? Is this related to any PEGA OOTB agent ? Do we need to implement any indexes ? or ay Hotfix or DSS ? I couldnt find any information regardng this table across PDN.

Queries for reference below :

1) SELECT "SKVS"."pyKey" AS "pyKey" , "SKVS"."pyParent" AS "pyParent" , "SKVS"."pyValue" AS "pyValue" , "SKVS"."pyVersion" AS "pyVersion" , "SKVS"."pyCreateDateTime" AS "pyCreateDateTime" , "SKVS"."pyUpdateDateTime" AS "pyUpdateDateTime" , "SKVS"."pyMode" AS "pyMode" , "SKVS"."pySessionId" AS "pySessionId" FROM dbo.pr_sys_serviceregistry_kvs "SKVS" WHERE  ( "SKVS"."pyKey" = ?  AND  ( "SKVS"."pySessionId" IS NULL OR  ( "SKVS"."pySessionId" IN (SELECT "NSRS"."pySessionId" AS "pySessionId" FROM dbo.pr_sys_serviceregistry "NSRS") AND "SKVS"."pySessionId" NOT IN (SELECT "FSRS"."pySessionId" AS "pySessionId" FROM dbo.pr_sys_serviceregistry "FSRS" WHERE  ( "FSRS"."pyLastSeenDateTime" <= (?  - "FSRS"."pyTimeout") ) ) )  )  )

2) SELECT "SSR"."pyName" AS "pyName" , "SSR"."pyAddress" AS "pyAddress" , "SSR"."pyPort" AS "pyPort" , "SSR"."pyState" AS "pyState" , "SSR"."pyNodeId" AS "pyNodeId" , "SSR"."pyVersion" AS "pyVersion" , "SSR"."pyMeta" AS "pyMeta" , "SSR"."pyTags" AS "pyTags" , "SSR"."pyTimeout" AS "pyTimeout" , "SSR"."pyStartTime" AS "pyStartTime" , "SSR"."pySessionId" AS "pySessionId" FROM dbo.pr_sys_serviceregistry "SSR" WHERE  ( "SSR"."pyName" = ?  AND "SSR"."pyLastSeenDateTime" > (?  - "SSR"."pyTimeout") )  ORDER BY 5 ASC, 10 DESC

3) SELECT "SKVS"."pyKey" AS "pyKey" , "SKVS"."pyParent" AS "pyParent" , "SKVS"."pyValue" AS "pyValue" , "SKVS"."pyVersion" AS "pyVersion" , "SKVS"."pyCreateDateTime" AS "pyCreateDateTime" , "SKVS"."pyUpdateDateTime" AS "pyUpdateDateTime" , "SKVS"."pyMode" AS "pyMode" , "SKVS"."pySessionId" AS "pySessionId" FROM dbo.pr_sys_serviceregistry_kvs "SKVS" WHERE  (  ( "SKVS"."pyKey" = ?  OR "SKVS"."pyParent" = ?  OR  "SKVS"."pyParent" LIKE ?   )  AND  ( "SKVS"."pySessionId" IS NULL OR  ( "SKVS"."pySessionId" IN (SELECT "NSRS"."pySessionId" AS "pySessionId" FROM dbo.pr_sys_serviceregistry "NSRS") AND "SKVS"."pySessionId" NOT IN (SELECT "FSRS"."pySessionId" AS "pySessionId" FROM dbo.pr_sys_serviceregistry "FSRS" WHERE  ( "FSRS"."pyLastSeenDateTime" <= (?  - "FSRS"."pyTimeout") ) ) )  )  )

4) SELECT CURRENT_TIMESTAMP AS "CurrentDateTime" FROM dbo.pr_sys_serviceregistry "SSR"

5) SELECT "SSR"."pyName" AS "pyName" , "SSR"."pyAddress" AS "pyAddress" , "SSR"."pyPort" AS "pyPort" , "SSR"."pyState" AS "pyState" , "SSR"."pyNodeId" AS "pyNodeId" , "SSR"."pyVersion" AS "pyVersion" , "SSR"."pyMeta" AS "pyMeta" , "SSR"."pyTags" AS "pyTags" , "SSR"."pyTimeout" AS "pyTimeout" , "SSR"."pyStartTime" AS "pyStartTime" , "SSR"."pySessionId" AS "pySessionId" FROM dbo.pr_sys_serviceregistry "SSR" WHERE  ( "SSR"."pyLastSeenDateTime" > (?  - "SSR"."pyTimeout") )  ORDER BY 5 ASC, 10 DESC

 

***Edited by Moderator: Pooja Gadige to add platform capability tag***
Pega Platform 8.4.2 System Administration