am atasat aici mai multe deadlock graph-uri care par a folosi acelasi index iTableName
ma poate ajuta cineva sa rezolv problema
http://s4.transfer.ro/storage/deadlock_graph-68e72.rar
asta e tabela respectiva
CREATE
TABLE [dbo].[SEQ_NUMBER_TABLE](
[SeqNo] [int]
NOT NULL,
[TableName] [varchar]
(30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
)
ON [PRIMARY]
si asta e indexul
CREATE
UNIQUE NONCLUSTERED INDEX [iTableName] ON [dbo].[SEQ_NUMBER_TABLE]
(
[TableName]
ASC
)
WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
are 153 de inregistrari si din ea se face doar select...e ca un nomenclator.
multumesc.
alex.