Hi Nita,

I assumed you performed an in-place upgrade. Did the in-place upgrade keep the existing instance name or was a new instance name added?

I am almost sure that the same...

The deadlock issue is resolved:-).

The issue of deadlock has been resolved by looking at not only the deadlock trace, but also the actual execution plan.

The deadlock trace pointed the direction...

I think I can resolve the deadlock issue by adding an index.

As shown in the above deadlock graph, the deadlock occurs against two processes, whilst each process is performing...

Indexes against table [dbo].[tbDSNET_DIM_File_IndexValues_DataState]

TABLE [dbo].[tbDSNET_DIM_File_IndexValues_DataState]

STORED PROCEDURE [dbo].[uspDSNET_DIM_FileInfo_Add]

Hi Gail Shaw and thanks for the information.

I've executed your SQL statement and this shows that against table tbDSNET_DIM_File_IndexValues_DataState the index PK_tbDSNET_DIM_File_IndexValues_DataState is being used. This is also confirmed...