![]() ![]() How can I resolve this type of deadlock? Any help would be appreciated. )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 = 90) ON )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON I tryed ROWLOCK, but it locked page too: exec sp_executesql N'DELETE FROM OBJEKT_PP_SUBJEKT WITH (XLOCK, ROWLOCK) WHERE ID = sp_executesql N'DELETE FROM OBJEKT_PP_SUBJEKT WITH (XLOCK, ROWLOCK) WHERE ID = is DDL: SET ANSI_NULLS ONĬONSTRAINT PRIMARY KEY CLUSTERED In the attachment, there is the simplified script of table create script. ![]() I am not an expert in the field of indexes. I have 5 indexes on table OBJEKT_PP_SUBJEKT Snapshot isolation and read commited snapshot are off. Two simple and equal commands were run from two concurrent threads via sp_executesql: exec sp_executesql N'DELETE FROM OBJEKT_PP_SUBJEKT WHERE ID = sp_executesql N'DELETE FROM OBJEKT_PP_SUBJEKT WHERE ID = SQL scripts were the part of sequence runned in the transaction. ![]() int)DELETE FROM OBJEKT_PP_SUBJEKT WHERE ID = 08:06:08,spid16s,Unknown,inputbuf 08:06:08,spid16s,Unknown,waiter id=process31f02d868 mode=S requestType=wait Here is my MS SQL server log: 08:06:08,spid16s,Unknown,waiter id=process314c1f868 mode=S requestType=wait ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |