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.