question

SQLDBA-7660 avatar image
0 Votes"
SQLDBA-7660 asked SeeyaXi-msft commented

Deadlock issue help

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.

117139-image.png






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

sql-server-generalsql-server-transact-sql
image.png (63.5 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SQLDBA-7660 ,

We have not received a response from you. Please let us know the progress.

0 Votes 0 ·
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @SQLDBA-7660 ,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.