Hi Team,

Below mentioned Deadlock Queries has been observed @ Production Environment.

Please suggest.

1) SELECT TOP 1000 [pxAssignedOperatorID] ,[pxObjClass] ,[pxRefObjectClass] ,[pxRefObjectInsName] ,[pxRefObjectKey] ,[pxServiceLevelName] ,[pxUrgencyAssign] ,[pxWorkGroup] ,[pyAssignmentStatus] ,[pyFlowType] ,[pyInstructions] ,[pyLabel] ,[pzInsKey] ,[pxApplication] ,[Market] ,[ReceivedDate] ,MemberID ,ProviderID ,DocumentID ,MemberName FROM [pc_assign_workbasket] where pxobjclass='Assign-WorkBasket' and pxRefObjectClass like 'Antm-%' and pxAssignedOperatorID = ? and pyAssignmentStatus like 'Open-Assigned-%' and pxWorkGroup like 'CompassClinical%' Order by ReceivedDate asc

2) SELECT "PC0"."pxUrgencyAssign" AS "pxUrgencyAssign" , "PC0"."pxRefObjectInsName" AS "pxRefObjectInsName" , "PC0"."pyLabel" AS "pyLabel" , "PC0"."pyAssignmentStatus" AS "pyAssignmentStatus" , "PC0"."pyInstructions" AS "pyInstructions" , "PC0"."pyAssignmentStatus" AS "pyAssignmentStatus" , "PC0"."pxDeadlineTime" AS "pxDeadlineTime" , "PC0"."pxAssignedOperatorID" AS "pxAssignedOperatorID" , "PC0"."pxUpdateOperator" AS "pxUpdateOperator" , "PC0"."pxUpdateDateTime" AS "pxUpdateDateTime" , "PC0"."pxGoalTime" AS "pxGoalTime" , "PC0"."pxCreateOpName" AS "pxCreateOpName" , "PC0"."pxCreateDateTime" AS "pxCreateDateTime" , "PC0"."pxTaskLabel" AS "pxTaskLabel" , "PC0"."pxAssignedUserName" AS "pxAssignedUserName" , "PC0"."pzInsKey" AS "pzInsKey" FROM dbo.pc_assign_worklist "PC0" WHERE ( "PC0"."pxAssignedOperatorID" = ? ) AND "PC0"."pxObjClass" = ? ORDER BY 1 DESC, 7 ASC, 13 DESC

3) SELECT "MemberID" AS "MemberID" , "pxCreateDateTime" AS "pxCreateDateTime" , "pxObjClass" AS "pxObjClass" , "pyID" AS "pyID" , "pyDescription" AS "pyDescription" , "pyStatusWork" AS "pyStatusWork" , "WorkbasketName" AS "WorkbasketName" , "MemberLOB" AS "MemberLOB" , "MemberFullName" AS "MemberFullName" , "ProviderName" AS "ProviderName" , "ProviderNumber" AS "ProviderNumber" , "pxCreateOperator" AS "pxCreateOperator" , "DualMemberID" AS "DualMemberID" , "DocumentID" AS "DocumentID" , "FaxWOID" AS "FaxWOID" , "pyResolvedTimestamp" AS "pyResolvedTimestamp" , "pxUpdateDateTime" AS "pxUpdateDateTime" , "pzInsKey" AS "pzInsKey" from dbo.CPMHC_WORK WHERE ( "MemberID" = ? ) AND "pxCreateDateTime" >= ? AND "pxCreateDateTime" <= ? AND ( "pxObjClass" NOT LIKE ? ) AND "pxObjClass" IS NOT NULL ORDER BY "pxCreateDateTime" DESC

4) delete from dbo.pr_idx_MemberBilling_SSNDeductions where pxInsIndexedKey = ? and pxIndexPurpose = ?

5) select pzPVStream from dbo.CPMHC_WORK where pzInsKey = ?

6) select pzPVStream , pxCommitDateTime from dbo.pc_assign_workbasket where pzInsKey = ?

***Edited by Moderator Marissa to update SR Details***