Deadlock issue help

Question

I am new and learning more about deadlock. recently we got this in production environment and not sure what it is telling me. Any help to resolve this, really appreciate it.

index code:

CREATE NONCLUSTERED INDEX [IX_arb] ON [dbo].[arb]
(
[set_id] ASC
)
INCLUDE([it_flg],[con_cd],[h_s],[e_cd])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF,
DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
FILLFACTOR = 100) ON [INDEXES]
GO

Answer 1

Hi @SQLDBA ,

A deadlock occurs when two or more tasks permanently block each other by each task having a lock on a resource which the other tasks are trying to lock.
Could you post the specific content of each query clearly (these are two processes)?

Best regards,
Seeya

Answer 2

The deadlock graph may look pretty, but it has too little information to actually explain why the deadlock happened. You need the the full XML for the deadlock to have all details. If you still have that around, you can post it here for analysis.