Question

1
Replies
10
Views
Close popover
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 213 posts
Anthem
Posted: February 9, 2021
Last activity: February 9, 2021

OOTB Blocking Queries.

Hi Team,

Please find the queries below which were blocked and creating high spike on waits in production environment. Furthermore, what is the purpose of each of these sql queries ?

1)SELECT [pyLastPulseDateTime] FROM [dbo].[pr_sys_statusnodes] WHERE [pzInsKey]=@1

2)select * from dbo.pr_sys_statusnodes where pzInsKey = @P0

3)UPDATE dbo.pr_operators SET "CTILastSignOn" = @P0 , "CTILoggedIn" = @P1 , "Company" = @P2 , "SessionID" = @P3 , "UserDomain" = @P4 , "pxCreateDateTime" = @P5 , "pxCreateOpName" = @P6 , "pxCreateOperator" = @P7 , "pxCreateSystemID" = @P8 , "pxInsName" = @P9 , "pxObjClass" = @P10 , "pxSaveDateTime" = @P11 , "pxUpdateDateTime" = @P12 , "pxUpdateOpName" = @P13 , "pxUpdateOperator" = @P14 , "pxUpdateSystemID" = @P15 , "pyAccessGroup" = @P16 , "pyAllowRuleCheckOut" = @P17 , "pyCalendar" = @P18 , "pyDefaultTimeZone" = @P19 , "pyEmailAddress" = @P20 , "pyExtension" = @P21 , "pyImageFileName" = @P22 , "pyLabel" = @P23 , "pyLastSignon" = @P24 , "pyLicenseType" = @P25 , "pyOpAvailable" = @P26 , "pyOrgDivision" = @P27 , "pyOrgUnit" = @P28 , "pyOrganization" = @P29 , "pyPosition" = @P30 , "pyReportTo" = @P31 , "pyRuleSetName" = @P32 , "pyUserIdentifier" = @P33 , "pyUserName" = @P34 , "pyWorkGroup" = @P35 , "Browser" = @P36 , pxCommitDateTime = CURRENT_TIMESTAMP , pzPVStream = @P37 WHERE pzInsKey = @P38

Any recommendations to resolve the same would be highly appreciated. Much obliged.

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