Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Deadlock чтение графа, как узнать параметры и причины блокировки при апдейте по PK  [new]
NIIIK
Member

Откуда: Россия, Ростовская область, г. Таганрог
Сообщений: 1295
Всем доброе время суток.

Попросили посмотреть на причины deadlock-ов на проекте к которому даже я когда-то давно приложил руку

В графе вот такая хрень...
+

2015-12-29 12:10:46.96 spid21s deadlock-list
2015-12-29 12:10:46.96 spid21s deadlock victim=process8294c8
2015-12-29 12:10:46.96 spid21s process-list
2015-12-29 12:10:46.96 spid21s process id=process8294c8 taskpriority=0 logused=0 waitresource=PAGE: 99:1:133232 waittime=4350 ownerId=45630 transactionname=UPDATE lasttranstarted=2015-12-29T12:10:42.607 XDES=0x80049a50 lockMode=U schedulerid=2 kpid=15736 status=suspended spid=61 sbid=2 ecid=4 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:10:42.603 lastbatchcompleted=2015-12-29T12:10:42.603 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=45630 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:10:46.96 spid21s executionStack
2015-12-29 12:10:46.97 spid21s frame procname=someDB_life_test.dbo.spSomeTable line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:10:46.97 spid21s update ede
2015-12-29 12:10:46.97 spid21s set ede.fkSomeLink = coalesce(@fkSomeLink, ede.fkSomeLink),
2015-12-29 12:10:46.97 spid21s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:10:46.97 spid21s from dbo.tSomeTable ede
2015-12-29 12:10:46.97 spid21s where ede.pk = @pkSomeTable
2015-12-29 12:10:46.97 spid21s --and (
2015-12-29 12:10:46.97 spid21s -- ede.fkSomeLink <> coalesce(@fkSomeLink, ede.fkSomeLink)
2015-12-29 12:10:46.97 spid21s -- or
2015-12-29 12:10:46.97 spid21s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:10:46.97 spid21s -- );
2015-12-29 12:10:46.97 spid21s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:10:46.97 spid21s EXEC @RETURN_VALUE = [dbo].[spSomeTable] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLink = @p3, @deleted = @p4
2015-12-29 12:10:46.97 spid21s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:10:46.97 spid21s unknown
2015-12-29 12:10:46.97 spid21s inputbuf
2015-12-29 12:10:46.97 spid21s process id=process816cabc8 taskpriority=0 logused=0 waitresource=PAGE: 99:1:41279 waittime=4351 ownerId=45631 transactionname=UPDATE lasttranstarted=2015-12-29T12:10:42.607 XDES=0x815f1b00 lockMode=U schedulerid=4 kpid=3932 status=suspended spid=89 sbid=2 ecid=4 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:10:42.603 lastbatchcompleted=2015-12-29T12:10:42.603 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=45631 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:10:46.97 spid21s executionStack
2015-12-29 12:10:46.97 spid21s frame procname=someDB_life_test.dbo.spSomeTable line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:10:46.97 spid21s update ede
2015-12-29 12:10:46.97 spid21s set ede.fkSomeLink = coalesce(@fkSomeLink, ede.fkSomeLink),
2015-12-29 12:10:46.97 spid21s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:10:46.97 spid21s from dbo.tSomeTable ede
2015-12-29 12:10:46.97 spid21s where ede.pk = @pkSomeTable
2015-12-29 12:10:46.97 spid21s --and (
2015-12-29 12:10:46.97 spid21s -- ede.fkSomeLink <> coalesce(@fkSomeLink, ede.fkSomeLink)
2015-12-29 12:10:46.97 spid21s -- or
2015-12-29 12:10:46.97 spid21s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:10:46.97 spid21s -- );
2015-12-29 12:10:46.97 spid21s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:10:46.97 spid21s EXEC @RETURN_VALUE = [dbo].[spSomeTable] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLink = @p3, @deleted = @p4



По факту там происходит (и много вызовов) апдейт строки по ПК причём той которая была только что вставлена.

Как вообще узнать что конкретно блокируется и из-за чего? Вставилась она, а апдейтися та же строка по факту.
Логика была insert/update (и апдейт после этого же инсёрта этой же строки ... что-то вроде как "без merge" писать его).

Как только убрал апдейт после инсёрта условием "что там и так те заченя" - даже воспроизвести дедлоки не могут.

В общем, как узнать что блокировалось и из-за чего? Что ещё с этого графа достать можно?

Заранее спасибо!
29 дек 15, 14:10    [18623017]     Ответить | Цитировать Сообщить модератору
 Re: Deadlock чтение графа, как узнать параметры и причины блокировки при апдейте по PK  [new]
NIIIK
Member

Откуда: Россия, Ростовская область, г. Таганрог
Сообщений: 1295
Кстати, этот апдейт был даже "по одному идешнику" везде, но этот идешник был везде НУЛЛ.

После инсёрта не делался output и соотвественно все эти апдейты срабатывали по null

Из-за этого может быть лок???
29 дек 15, 14:23    [18623089]     Ответить | Цитировать Сообщить модератору
 Re: Deadlock чтение графа, как узнать параметры и причины блокировки при апдейте по PK  [new]
invm
Member

Откуда: Москва
Сообщений: 9413
Граф неполный.

Из показанного можно предположить:
1. Т.к. waitresource=PAGE и lockMode=U, то ПК на dbo.tSomeTable создан с опцией allow_row_locks = off, плюс есть еще индекс по fkSomeLink.
2. В конфликтующих сессиях в одной транзакции осуществляется множественный update dbo.tSomeTable по пересекающемуся подмножеству значений @pkSomeTable и update'ы по одним и тем же значениям @pkSomeTable вызываются в разном порядке.

Дедлок возникает, когда сессия1 удерживает X на страницу А и хочет U на страницу Б, а сессия2, соответственно, наоборот.
29 дек 15, 15:05    [18623294]     Ответить | Цитировать Сообщить модератору
 Re: Deadlock чтение графа, как узнать параметры и причины блокировки при апдейте по PK  [new]
NIIIK
Member

Откуда: Россия, Ростовская область, г. Таганрог
Сообщений: 1295
invm,

Спасибо за ответ

Более полный лог такой
+

2015-12-29 12:10:46.96 spid21s deadlock-list
2015-12-29 12:10:46.96 spid21s deadlock victim=process8294c8
2015-12-29 12:10:46.96 spid21s process-list
2015-12-29 12:10:46.96 spid21s process id=process8294c8 taskpriority=0 logused=0 waitresource=PAGE: 99:1:133232 waittime=4350 ownerId=45630 transactionname=UPDATE lasttranstarted=2015-12-29T12:10:42.607 XDES=0x80049a50 lockMode=U schedulerid=2 kpid=15736 status=suspended spid=61 sbid=2 ecid=4 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:10:42.603 lastbatchcompleted=2015-12-29T12:10:42.603 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=45630 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:10:46.96 spid21s executionStack
2015-12-29 12:10:46.97 spid21s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:10:46.97 spid21s update ede
2015-12-29 12:10:46.97 spid21s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:10:46.97 spid21s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:10:46.97 spid21s from dbo.tSomeTableEntity ede
2015-12-29 12:10:46.97 spid21s where ede.pk = @pkSomeTableEntity
2015-12-29 12:10:46.97 spid21s --and (
2015-12-29 12:10:46.97 spid21s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:10:46.97 spid21s -- or
2015-12-29 12:10:46.97 spid21s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:10:46.97 spid21s -- );
2015-12-29 12:10:46.97 spid21s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:10:46.97 spid21s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
---
2015-12-29 12:24:48.33 spid26s update ede
2015-12-29 12:24:48.33 spid26s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:24:48.33 spid26s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:24:48.33 spid26s from dbo.tSomeTableEntity ede
2015-12-29 12:24:48.33 spid26s where ede.pk = @pkSomeTableEntity
2015-12-29 12:24:48.33 spid26s --and (
2015-12-29 12:24:48.33 spid26s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:24:48.33 spid26s -- or
2015-12-29 12:24:48.33 spid26s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:24:48.33 spid26s -- );
2015-12-29 12:24:48.33 spid26s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:24:48.33 spid26s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:24:48.33 spid26s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:24:48.33 spid26s unknown
2015-12-29 12:24:48.33 spid26s inputbuf
2015-12-29 12:24:48.33 spid26s process id=process841674c8 taskpriority=0 logused=0 waitresource=PAGE: 99:1:356574 waittime=7556 ownerId=260661 transactionname=UPDATE lasttranstarted=2015-12-29T12:24:40.777 XDES=0x92f70b50 lockMode=U schedulerid=1 kpid=15172 status=suspended spid=101 sbid=2 ecid=3 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:24:38.127 lastbatchcompleted=2015-12-29T12:24:38.123 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=260661 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:24:48.33 spid26s executionStack
2015-12-29 12:24:48.33 spid26s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:24:48.33 spid26s update ede
2015-12-29 12:24:48.33 spid26s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:24:48.33 spid26s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:24:48.33 spid26s from dbo.tSomeTableEntity ede
2015-12-29 12:24:48.33 spid26s where ede.pk = @pkSomeTableEntity
2015-12-29 12:24:48.33 spid26s --and (
2015-12-29 12:24:48.33 spid26s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:24:48.33 spid26s -- or
2015-12-29 12:24:48.33 spid26s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:24:48.33 spid26s -- );
2015-12-29 12:24:48.33 spid26s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:24:48.33 spid26s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:24:48.33 spid26s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:24:48.33 spid26s unknown
2015-12-29 12:24:48.33 spid26s inputbuf
2015-12-29 12:24:48.33 spid26s process id=process54f048 taskpriority=0 logused=10000 waittime=2321 schedulerid=1 kpid=14364 status=suspended spid=96 sbid=2 ecid=0 priority=0 trancount=2 lastbatchstarted=2015-12-29T12:24:38.037 lastbatchcompleted=2015-12-29T12:24:37.980 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 loginname=sql2008 isolationlevel=read committed (2) xactid=260643 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:24:48.33 spid26s executionStack
2015-12-29 12:24:48.33 spid26s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:24:48.33 spid26s update ede
2015-12-29 12:24:48.33 spid26s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:24:48.33 spid26s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:24:48.33 spid26s from dbo.tSomeTableEntity ede
2015-12-29 12:24:48.33 spid26s where ede.pk = @pkSomeTableEntity
2015-12-29 12:24:48.33 spid26s --and (
2015-12-29 12:24:48.33 spid26s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:24:48.33 spid26s -- or
2015-12-29 12:24:48.33 spid26s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:24:48.33 spid26s -- );
2015-12-29 12:24:48.33 spid26s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:24:48.33 spid26s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:24:48.33 spid26s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:24:48.33 spid26s unknown
2015-12-29 12:24:48.33 spid26s inputbuf
2015-12-29 12:24:48.33 spid26s (@p0 uniqueidentifier,@p1 uniqueidentifier,@p2 nvarchar(4000),@p3 uniqueidentifier,@p4 bit,@RETURN_VALUE int output)EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:24:48.34 spid26s resource-list
2015-12-29 12:24:48.34 spid26s pagelock fileid=1 pageid=356574 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockc224d200 mode=U associatedObjectId=72057594041401344
2015-12-29 12:24:48.34 spid26s owner-list
2015-12-29 12:24:48.34 spid26s waiter-list
2015-12-29 12:24:48.34 spid26s waiter id=process816cbdc8 mode=U requestType=wait
2015-12-29 12:24:48.34 spid26s pagelock fileid=1 pageid=356574 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockc224d200 mode=U associatedObjectId=72057594041401344
2015-12-29 12:24:48.34 spid26s owner-list
2015-12-29 12:24:48.34 spid26s owner id=process54f048 mode=U
2015-12-29 12:24:48.34 spid26s waiter-list
2015-12-29 12:24:48.34 spid26s waiter id=process841674c8 mode=U requestType=wait
2015-12-29 12:24:48.34 spid26s exchangeEvent id=Pipedf51c580 WaitType=e_waitPipeGetRow nodeId=9
2015-12-29 12:24:48.34 spid26s owner-list
2015-12-29 12:24:48.34 spid26s owner id=process816cbdc8
2015-12-29 12:24:48.34 spid26s waiter-list
2015-12-29 12:24:48.34 spid26s waiter id=process54f048
2015-12-29 12:25:28.98 spid29s deadlock-list
2015-12-29 12:25:28.98 spid29s deadlock victim=processe6022508
2015-12-29 12:25:28.98 spid29s process-list
2015-12-29 12:25:28.98 spid29s process id=processe6022508 taskpriority=0 logused=0 waitresource=PAGE: 99:1:55781 waittime=4177 ownerId=274805 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0x80049a50 lockMode=U schedulerid=2 kpid=14000 status=suspended spid=96 sbid=2 ecid=3 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.790 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274805 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:28.98 spid29s executionStack
2015-12-29 12:25:28.98 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:28.98 spid29s update ede
2015-12-29 12:25:28.98 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:28.98 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.98 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:28.98 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:28.98 spid29s --and (
2015-12-29 12:25:28.98 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:28.98 spid29s -- or
2015-12-29 12:25:28.98 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.98 spid29s -- );
2015-12-29 12:25:28.98 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:28.98 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:28.98 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:28.98 spid29s unknown
2015-12-29 12:25:28.98 spid29s inputbuf
2015-12-29 12:25:28.98 spid29s process id=process84167288 taskpriority=0 logused=0 waitresource=PAGE: 99:1:55591 waittime=4178 ownerId=274805 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0x92f70b50 lockMode=U schedulerid=1 kpid=3776 status=suspended spid=96 sbid=2 ecid=2 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.790 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274805 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:28.98 spid29s executionStack
2015-12-29 12:25:28.98 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:28.98 spid29s update ede
2015-12-29 12:25:28.98 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:28.98 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.98 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:28.98 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:28.98 spid29s --and (
2015-12-29 12:25:28.98 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:28.98 spid29s -- or
2015-12-29 12:25:28.98 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s -- );
2015-12-29 12:25:28.99 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:28.99 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:28.99 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:28.99 spid29s unknown
2015-12-29 12:25:28.99 spid29s inputbuf
2015-12-29 12:25:28.99 spid29s process id=process816cb948 taskpriority=0 logused=0 waitresource=PAGE: 99:1:55591 waittime=4177 ownerId=274805 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0x815f1620 lockMode=U schedulerid=4 kpid=15864 status=suspended spid=96 sbid=2 ecid=4 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.790 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274805 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:28.99 spid29s executionStack
2015-12-29 12:25:28.99 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:28.99 spid29s update ede
2015-12-29 12:25:28.99 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:28.99 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:28.99 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:28.99 spid29s --and (
2015-12-29 12:25:28.99 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:28.99 spid29s -- or
2015-12-29 12:25:28.99 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s -- );
2015-12-29 12:25:28.99 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:28.99 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:28.99 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:28.99 spid29s unknown
2015-12-29 12:25:28.99 spid29s inputbuf
2015-12-29 12:25:28.99 spid29s process id=processe60222c8 taskpriority=0 logused=0 waitresource=PAGE: 99:1:356574 waittime=4185 ownerId=274804 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0x800497e0 lockMode=U schedulerid=2 kpid=15848 status=suspended spid=68 sbid=2 ecid=1 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.793 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274804 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:28.99 spid29s executionStack
2015-12-29 12:25:28.99 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:28.99 spid29s update ede
2015-12-29 12:25:28.99 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:28.99 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:28.99 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:28.99 spid29s --and (
2015-12-29 12:25:28.99 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:28.99 spid29s -- or
2015-12-29 12:25:28.99 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s -- );
2015-12-29 12:25:28.99 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:28.99 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:28.99 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:28.99 spid29s unknown
2015-12-29 12:25:28.99 spid29s inputbuf
2015-12-29 12:25:28.99 spid29s process id=process84166748 taskpriority=0 logused=0 waitresource=PAGE: 99:1:41279 waittime=4186 ownerId=274804 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0x8004dd20 lockMode=U schedulerid=1 kpid=13868 status=suspended spid=68 sbid=2 ecid=3 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.793 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274804 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:28.99 spid29s executionStack
2015-12-29 12:25:28.99 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:28.99 spid29s update ede
2015-12-29 12:25:28.99 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:28.99 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:28.99 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:28.99 spid29s --and (
2015-12-29 12:25:28.99 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:28.99 spid29s -- or
2015-12-29 12:25:28.99 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s -- );
2015-12-29 12:25:28.99 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:28.99 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:28.99 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:28.99 spid29s unknown
2015-12-29 12:25:28.99 spid29s inputbuf
2015-12-29 12:25:28.99 spid29s process id=processa7103dc8 taskpriority=0 logused=0 waitresource=PAGE: 99:1:133232 waittime=4186 ownerId=274804 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0xa68eb9f0 lockMode=U schedulerid=3 kpid=16352 status=suspended spid=68 sbid=2 ecid=2 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.793 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274804 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:28.99 spid29s executionStack
2015-12-29 12:25:28.99 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:28.99 spid29s update ede
2015-12-29 12:25:28.99 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:28.99 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:28.99 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:28.99 spid29s --and (
2015-12-29 12:25:28.99 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:28.99 spid29s -- or
2015-12-29 12:25:28.99 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s -- );
2015-12-29 12:25:28.99 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:28.99 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:28.99 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:28.99 spid29s unknown
2015-12-29 12:25:28.99 spid29s inputbuf
2015-12-29 12:25:28.99 spid29s process id=processa7103948 taskpriority=0 logused=0 waitresource=PAGE: 99:1:55685 waittime=4178 ownerId=274805 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0xa3f8db60 lockMode=U schedulerid=3 kpid=2168 status=suspended spid=96 sbid=2 ecid=1 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.790 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274805 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:28.99 spid29s executionStack
2015-12-29 12:25:28.99 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:28.99 spid29s update ede
2015-12-29 12:25:28.99 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:28.99 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:28.99 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:28.99 spid29s --and (
2015-12-29 12:25:28.99 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:28.99 spid29s -- or
2015-12-29 12:25:28.99 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s -- );
2015-12-29 12:25:28.99 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:28.99 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:28.99 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:28.99 spid29s unknown
2015-12-29 12:25:28.99 spid29s inputbuf
2015-12-29 12:25:28.99 spid29s process id=process829a7b88 taskpriority=0 logused=10000 waittime=3639 schedulerid=3 kpid=15260 status=suspended spid=68 sbid=2 ecid=0 priority=0 trancount=2 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.793 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 loginname=sql2008 isolationlevel=read committed (2) xactid=274804 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:28.99 spid29s executionStack
2015-12-29 12:25:28.99 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:28.99 spid29s update ede
2015-12-29 12:25:28.99 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:28.99 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:28.99 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:28.99 spid29s --and (
2015-12-29 12:25:28.99 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:28.99 spid29s -- or
2015-12-29 12:25:28.99 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s -- );
2015-12-29 12:25:28.99 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:28.99 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:28.99 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:28.99 spid29s unknown
2015-12-29 12:25:28.99 spid29s inputbuf
2015-12-29 12:25:28.99 spid29s (@p0 uniqueidentifier,@p1 uniqueidentifier,@p2 nvarchar(4000),@p3 uniqueidentifier,@p4 bit,@RETURN_VALUE int output)EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:28.99 spid29s resource-list
2015-12-29 12:25:28.99 spid29s pagelock fileid=1 pageid=55781 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockccb42480 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:28.99 spid29s owner-list
2015-12-29 12:25:28.99 spid29s owner id=process829a7b88 mode=U
2015-12-29 12:25:28.99 spid29s waiter-list
2015-12-29 12:25:28.99 spid29s waiter id=processe6022508 mode=U requestType=wait
2015-12-29 12:25:28.99 spid29s pagelock fileid=1 pageid=55591 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockca1e9a00 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:28.99 spid29s owner-list
2015-12-29 12:25:28.99 spid29s owner id=process829a7b88 mode=U
2015-12-29 12:25:28.99 spid29s waiter-list
2015-12-29 12:25:28.99 spid29s waiter id=process84167288 mode=U requestType=wait
2015-12-29 12:25:28.99 spid29s pagelock fileid=1 pageid=55591 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockca1e9a00 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:28.99 spid29s owner-list
2015-12-29 12:25:28.99 spid29s waiter-list
2015-12-29 12:25:28.99 spid29s waiter id=process816cb948 mode=U requestType=wait
2015-12-29 12:25:28.99 spid29s pagelock fileid=1 pageid=356574 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockcd936080 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:28.99 spid29s owner-list
2015-12-29 12:25:28.99 spid29s owner id=processe6022508 mode=U
2015-12-29 12:25:28.99 spid29s waiter-list
2015-12-29 12:25:28.99 spid29s waiter id=processe60222c8 mode=U requestType=wait
2015-12-29 12:25:28.99 spid29s pagelock fileid=1 pageid=41279 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockbedec980 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:28.99 spid29s owner-list
2015-12-29 12:25:28.99 spid29s owner id=processa7103948 mode=U
2015-12-29 12:25:28.99 spid29s waiter-list
2015-12-29 12:25:28.99 spid29s waiter id=process84166748 mode=U requestType=wait
2015-12-29 12:25:28.99 spid29s pagelock fileid=1 pageid=133232 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockc3122a80 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:28.99 spid29s owner-list
2015-12-29 12:25:28.99 spid29s owner id=processe6022508 mode=U
2015-12-29 12:25:28.99 spid29s waiter-list
2015-12-29 12:25:28.99 spid29s waiter id=processa7103dc8 mode=U requestType=wait
2015-12-29 12:25:28.99 spid29s pagelock fileid=1 pageid=55685 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockc613b680 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:28.99 spid29s owner-list
2015-12-29 12:25:28.99 spid29s owner id=process829a7b88 mode=U
2015-12-29 12:25:28.99 spid29s waiter-list
2015-12-29 12:25:28.99 spid29s waiter id=processa7103948 mode=U requestType=wait
2015-12-29 12:25:28.99 spid29s exchangeEvent id=Pipee52ac580 WaitType=e_waitPipeGetRow nodeId=9
2015-12-29 12:25:28.99 spid29s owner-list
2015-12-29 12:25:28.99 spid29s owner id=processe60222c8
2015-12-29 12:25:28.99 spid29s owner id=processa7103dc8
2015-12-29 12:25:28.99 spid29s owner id=process84166748
2015-12-29 12:25:28.99 spid29s waiter-list
2015-12-29 12:25:28.99 spid29s waiter id=process829a7b88
2015-12-29 12:25:28.99 spid29s deadlock-list
2015-12-29 12:25:28.99 spid29s deadlock victim=process84167288
2015-12-29 12:25:28.99 spid29s process-list
2015-12-29 12:25:28.99 spid29s process id=processe6022508 taskpriority=0 logused=0 waitresource=PAGE: 99:1:55781 waittime=4178 ownerId=274805 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0x80049a50 lockMode=U schedulerid=2 kpid=14000 status=suspended spid=96 sbid=2 ecid=3 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.790 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274805 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:28.99 spid29s executionStack
2015-12-29 12:25:28.99 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:28.99 spid29s update ede
2015-12-29 12:25:28.99 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:28.99 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:28.99 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:28.99 spid29s --and (
2015-12-29 12:25:28.99 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:28.99 spid29s -- or
2015-12-29 12:25:28.99 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s -- );
2015-12-29 12:25:28.99 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:28.99 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:28.99 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:28.99 spid29s unknown
2015-12-29 12:25:28.99 spid29s inputbuf
2015-12-29 12:25:28.99 spid29s process id=process84167288 taskpriority=0 logused=0 waitresource=PAGE: 99:1:55591 waittime=4178 ownerId=274805 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0x92f70b50 lockMode=U schedulerid=1 kpid=3776 status=suspended spid=96 sbid=2 ecid=2 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.790 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274805 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:28.99 spid29s executionStack
2015-12-29 12:25:28.99 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:28.99 spid29s update ede
2015-12-29 12:25:28.99 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:28.99 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:28.99 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:28.99 spid29s --and (
2015-12-29 12:25:28.99 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:28.99 spid29s -- or
2015-12-29 12:25:28.99 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s -- );
2015-12-29 12:25:28.99 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:28.99 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:28.99 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:28.99 spid29s unknown
2015-12-29 12:25:28.99 spid29s inputbuf
2015-12-29 12:25:28.99 spid29s process id=process816cb948 taskpriority=0 logused=0 waitresource=PAGE: 99:1:55591 waittime=4177 ownerId=274805 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0x815f1620 lockMode=U schedulerid=4 kpid=15864 status=suspended spid=96 sbid=2 ecid=4 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.790 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274805 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:28.99 spid29s executionStack
2015-12-29 12:25:28.99 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:28.99 spid29s update ede
2015-12-29 12:25:28.99 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:28.99 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:28.99 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:28.99 spid29s --and (
2015-12-29 12:25:28.99 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:28.99 spid29s -- or
2015-12-29 12:25:28.99 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:28.99 spid29s -- );
2015-12-29 12:25:28.99 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:28.99 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:28.99 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:28.99 spid29s unknown
2015-12-29 12:25:28.99 spid29s inputbuf
2015-12-29 12:25:28.99 spid29s process id=processe60222c8 taskpriority=0 logused=0 waitresource=PAGE: 99:1:356574 waittime=4186 ownerId=274804 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0x800497e0 lockMode=U schedulerid=2 kpid=15848 status=suspended spid=68 sbid=2 ecid=1 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.793 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274804 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:28.99 spid29s executionStack
2015-12-29 12:25:29.00 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:29.00 spid29s update ede
2015-12-29 12:25:29.00 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:29.00 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:29.00 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:29.00 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:29.00 spid29s --and (
2015-12-29 12:25:29.00 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:29.00 spid29s -- or
2015-12-29 12:25:29.00 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:29.00 spid29s -- );
2015-12-29 12:25:29.00 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:29.00 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:29.00 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:29.00 spid29s unknown
2015-12-29 12:25:29.00 spid29s inputbuf
2015-12-29 12:25:29.00 spid29s process id=process84166748 taskpriority=0 logused=0 waitresource=PAGE: 99:1:41279 waittime=4186 ownerId=274804 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0x8004dd20 lockMode=U schedulerid=1 kpid=13868 status=suspended spid=68 sbid=2 ecid=3 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.793 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274804 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:29.00 spid29s executionStack
2015-12-29 12:25:29.00 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:29.00 spid29s update ede
2015-12-29 12:25:29.00 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:29.00 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:29.00 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:29.00 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:29.00 spid29s --and (
2015-12-29 12:25:29.00 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:29.00 spid29s -- or
2015-12-29 12:25:29.00 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:29.00 spid29s -- );
2015-12-29 12:25:29.00 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:29.00 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:29.00 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:29.00 spid29s unknown
2015-12-29 12:25:29.00 spid29s inputbuf
2015-12-29 12:25:29.00 spid29s process id=processa7103dc8 taskpriority=0 logused=0 waitresource=PAGE: 99:1:133232 waittime=4186 ownerId=274804 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0xa68eb9f0 lockMode=U schedulerid=3 kpid=16352 status=suspended spid=68 sbid=2 ecid=2 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.793 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274804 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:29.00 spid29s executionStack
2015-12-29 12:25:29.00 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:29.00 spid29s update ede
2015-12-29 12:25:29.00 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:29.00 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:29.00 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:29.00 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:29.00 spid29s --and (
2015-12-29 12:25:29.00 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:29.00 spid29s -- or
2015-12-29 12:25:29.00 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:29.00 spid29s -- );
2015-12-29 12:25:29.00 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:29.00 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:29.00 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:29.00 spid29s unknown
2015-12-29 12:25:29.00 spid29s inputbuf
2015-12-29 12:25:29.00 spid29s process id=processa7103948 taskpriority=0 logused=0 waitresource=PAGE: 99:1:55685 waittime=4178 ownerId=274805 transactionname=UPDATE lasttranstarted=2015-12-29T12:25:24.793 XDES=0xa3f8db60 lockMode=U schedulerid=3 kpid=2168 status=suspended spid=96 sbid=2 ecid=1 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.790 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=274805 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:29.00 spid29s executionStack
2015-12-29 12:25:29.00 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:29.00 spid29s update ede
2015-12-29 12:25:29.00 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:29.00 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:29.00 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:29.00 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:29.00 spid29s --and (
2015-12-29 12:25:29.00 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:29.00 spid29s -- or
2015-12-29 12:25:29.00 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:29.00 spid29s -- );
2015-12-29 12:25:29.00 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:29.00 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:29.00 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:29.00 spid29s unknown
2015-12-29 12:25:29.00 spid29s inputbuf
2015-12-29 12:25:29.00 spid29s process id=process829a7b88 taskpriority=0 logused=10000 waittime=3640 schedulerid=3 kpid=15260 status=suspended spid=68 sbid=2 ecid=0 priority=0 trancount=2 lastbatchstarted=2015-12-29T12:25:24.793 lastbatchcompleted=2015-12-29T12:25:24.793 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 loginname=sql2008 isolationlevel=read committed (2) xactid=274804 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:25:29.00 spid29s executionStack
2015-12-29 12:25:29.00 spid29s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:25:29.00 spid29s update ede
2015-12-29 12:25:29.00 spid29s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:25:29.00 spid29s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:25:29.00 spid29s from dbo.tSomeTableEntity ede
2015-12-29 12:25:29.00 spid29s where ede.pk = @pkSomeTableEntity
2015-12-29 12:25:29.00 spid29s --and (
2015-12-29 12:25:29.00 spid29s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:25:29.00 spid29s -- or
2015-12-29 12:25:29.00 spid29s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:25:29.00 spid29s -- );
2015-12-29 12:25:29.00 spid29s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:25:29.00 spid29s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:29.00 spid29s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:25:29.00 spid29s unknown
2015-12-29 12:25:29.00 spid29s inputbuf
2015-12-29 12:25:29.00 spid29s (@p0 uniqueidentifier,@p1 uniqueidentifier,@p2 nvarchar(4000),@p3 uniqueidentifier,@p4 bit,@RETURN_VALUE int output)EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:25:29.00 spid29s resource-list
2015-12-29 12:25:29.00 spid29s pagelock fileid=1 pageid=55781 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockccb42480 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:29.00 spid29s owner-list
2015-12-29 12:25:29.00 spid29s owner id=process829a7b88 mode=U
2015-12-29 12:25:29.00 spid29s waiter-list
2015-12-29 12:25:29.00 spid29s waiter id=processe6022508 mode=U requestType=wait
2015-12-29 12:25:29.00 spid29s pagelock fileid=1 pageid=55591 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockca1e9a00 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:29.00 spid29s owner-list
2015-12-29 12:25:29.00 spid29s owner id=process829a7b88 mode=U
2015-12-29 12:25:29.00 spid29s waiter-list
2015-12-29 12:25:29.00 spid29s waiter id=process84167288 mode=U requestType=wait
2015-12-29 12:25:29.00 spid29s pagelock fileid=1 pageid=55591 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockca1e9a00 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:29.00 spid29s owner-list
2015-12-29 12:25:29.00 spid29s waiter-list
2015-12-29 12:25:29.00 spid29s waiter id=process816cb948 mode=U requestType=wait
2015-12-29 12:25:29.00 spid29s pagelock fileid=1 pageid=356574 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockcd936080 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:29.00 spid29s owner-list
2015-12-29 12:25:29.00 spid29s owner id=processe6022508 mode=U
2015-12-29 12:25:29.00 spid29s waiter-list
2015-12-29 12:25:29.00 spid29s waiter id=processe60222c8 mode=U requestType=wait
2015-12-29 12:25:29.00 spid29s pagelock fileid=1 pageid=41279 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockbedec980 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:29.00 spid29s owner-list
2015-12-29 12:25:29.00 spid29s owner id=processa7103948 mode=U
2015-12-29 12:25:29.00 spid29s waiter-list
2015-12-29 12:25:29.00 spid29s waiter id=process84166748 mode=U requestType=wait
2015-12-29 12:25:29.00 spid29s pagelock fileid=1 pageid=133232 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockc3122a80 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:29.00 spid29s owner-list
2015-12-29 12:25:29.00 spid29s owner id=processe6022508 mode=U
2015-12-29 12:25:29.00 spid29s waiter-list
2015-12-29 12:25:29.00 spid29s waiter id=processa7103dc8 mode=U requestType=wait
2015-12-29 12:25:29.00 spid29s pagelock fileid=1 pageid=55685 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockc613b680 mode=U associatedObjectId=72057594041401344
2015-12-29 12:25:29.00 spid29s owner-list
2015-12-29 12:25:29.00 spid29s owner id=process829a7b88 mode=U
2015-12-29 12:25:29.00 spid29s waiter-list
2015-12-29 12:25:29.00 spid29s waiter id=processa7103948 mode=U requestType=wait
2015-12-29 12:25:29.00 spid29s exchangeEvent id=Pipee52ac580 WaitType=e_waitPipeGetRow nodeId=9
2015-12-29 12:25:29.00 spid29s owner-list
2015-12-29 12:25:29.00 spid29s owner id=processe60222c8
2015-12-29 12:25:29.00 spid29s owner id=processa7103dc8
2015-12-29 12:25:29.00 spid29s owner id=process84166748
2015-12-29 12:25:29.00 spid29s waiter-list
2015-12-29 12:25:29.00 spid29s waiter id=process829a7b88
2015-12-29 12:26:46.47 spid25s deadlock-list
2015-12-29 12:26:46.47 spid25s deadlock victim=process816cbdc8
2015-12-29 12:26:46.47 spid25s process-list
2015-12-29 12:26:46.47 spid25s process id=process816cbdc8 taskpriority=0 logused=0 waitresource=PAGE: 99:1:133232 waittime=4991 ownerId=291894 transactionname=UPDATE lasttranstarted=2015-12-29T12:26:41.483 XDES=0x80041690 lockMode=U schedulerid=4 kpid=15968 status=suspended spid=100 sbid=2 ecid=1 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:26:41.483 lastbatchcompleted=2015-12-29T12:26:41.460 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=291894 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:26:46.47 spid25s executionStack
2015-12-29 12:26:46.47 spid25s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:26:46.47 spid25s update ede
2015-12-29 12:26:46.47 spid25s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:26:46.47 spid25s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:26:46.47 spid25s from dbo.tSomeTableEntity ede
2015-12-29 12:26:46.47 spid25s where ede.pk = @pkSomeTableEntity
2015-12-29 12:26:46.47 spid25s --and (
2015-12-29 12:26:46.47 spid25s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:26:46.47 spid25s -- or
2015-12-29 12:26:46.47 spid25s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:26:46.47 spid25s -- );
2015-12-29 12:26:46.47 spid25s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:26:46.47 spid25s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:26:46.47 spid25s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:26:46.47 spid25s unknown
2015-12-29 12:26:46.47 spid25s inputbuf
2015-12-29 12:26:46.47 spid25s process id=process841662c8 taskpriority=0 logused=0 waitresource=PAGE: 99:1:41279 waittime=4991 ownerId=291894 transactionname=UPDATE lasttranstarted=2015-12-29T12:26:41.483 XDES=0x99d3a930 lockMode=U schedulerid=1 kpid=13868 status=suspended spid=100 sbid=2 ecid=4 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:26:41.483 lastbatchcompleted=2015-12-29T12:26:41.460 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=291894 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:26:46.47 spid25s executionStack
2015-12-29 12:26:46.47 spid25s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:26:46.47 spid25s update ede
2015-12-29 12:26:46.47 spid25s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:26:46.47 spid25s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:26:46.47 spid25s from dbo.tSomeTableEntity ede
2015-12-29 12:26:46.47 spid25s where ede.pk = @pkSomeTableEntity
2015-12-29 12:26:46.47 spid25s --and (
2015-12-29 12:26:46.47 spid25s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:26:46.47 spid25s -- or
2015-12-29 12:26:46.47 spid25s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:26:46.47 spid25s -- );
2015-12-29 12:26:46.47 spid25s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:26:46.47 spid25s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:26:46.47 spid25s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:26:46.47 spid25s unknown
2015-12-29 12:26:46.47 spid25s inputbuf
2015-12-29 12:26:46.47 spid25s process id=processe6022088 taskpriority=0 logused=0 waitresource=PAGE: 99:1:356574 waittime=4986 ownerId=291888 transactionname=UPDATE lasttranstarted=2015-12-29T12:26:41.480 XDES=0x80049d20 lockMode=U schedulerid=2 kpid=15648 status=suspended spid=96 sbid=2 ecid=1 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:26:41.437 lastbatchcompleted=2015-12-29T12:26:41.427 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=291888 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:26:46.47 spid25s executionStack
2015-12-29 12:26:46.47 spid25s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:26:46.47 spid25s update ede
2015-12-29 12:26:46.47 spid25s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:26:46.47 spid25s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:26:46.47 spid25s from dbo.tSomeTableEntity ede
2015-12-29 12:26:46.47 spid25s where ede.pk = @pkSomeTableEntity
2015-12-29 12:26:46.47 spid25s --and (
2015-12-29 12:26:46.47 spid25s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:26:46.47 spid25s -- or
2015-12-29 12:26:46.47 spid25s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:26:46.47 spid25s -- );
2015-12-29 12:26:46.48 spid25s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:26:46.48 spid25s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:26:46.48 spid25s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:26:46.48 spid25s unknown
2015-12-29 12:26:46.48 spid25s inputbuf
2015-12-29 12:26:46.48 spid25s process id=processa7103dc8 taskpriority=0 logused=0 waitresource=PAGE: 99:1:356574 waittime=4986 ownerId=291888 transactionname=UPDATE lasttranstarted=2015-12-29T12:26:41.480 XDES=0xd1275cd0 lockMode=U schedulerid=3 kpid=13660 status=suspended spid=96 sbid=2 ecid=4 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:26:41.437 lastbatchcompleted=2015-12-29T12:26:41.427 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=291888 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:26:46.48 spid25s executionStack
2015-12-29 12:26:46.48 spid25s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:26:46.48 spid25s update ede
2015-12-29 12:26:46.48 spid25s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:26:46.48 spid25s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:26:46.48 spid25s from dbo.tSomeTableEntity ede
2015-12-29 12:26:46.48 spid25s where ede.pk = @pkSomeTableEntity
2015-12-29 12:26:46.48 spid25s --and (
2015-12-29 12:26:46.48 spid25s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:26:46.48 spid25s -- or
2015-12-29 12:26:46.48 spid25s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:26:46.48 spid25s -- );
2015-12-29 12:26:46.48 spid25s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:26:46.48 spid25s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:26:46.48 spid25s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:26:46.48 spid25s unknown
2015-12-29 12:26:46.48 spid25s inputbuf
2015-12-29 12:26:46.48 spid25s process id=process54fdc8 taskpriority=0 logused=10000 waittime=4789 schedulerid=1 kpid=15172 status=suspended spid=100 sbid=2 ecid=0 priority=0 trancount=2 lastbatchstarted=2015-12-29T12:26:41.483 lastbatchcompleted=2015-12-29T12:26:41.460 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 loginname=sql2008 isolationlevel=read committed (2) xactid=291894 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:26:46.48 spid25s executionStack
2015-12-29 12:26:46.48 spid25s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:26:46.48 spid25s update ede
2015-12-29 12:26:46.48 spid25s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:26:46.48 spid25s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:26:46.48 spid25s from dbo.tSomeTableEntity ede
2015-12-29 12:26:46.48 spid25s where ede.pk = @pkSomeTableEntity
2015-12-29 12:26:46.48 spid25s --and (
2015-12-29 12:26:46.48 spid25s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:26:46.48 spid25s -- or
2015-12-29 12:26:46.48 spid25s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:26:46.48 spid25s -- );
2015-12-29 12:26:46.48 spid25s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:26:46.48 spid25s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:26:46.48 spid25s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:26:46.48 spid25s unknown
2015-12-29 12:26:46.48 spid25s inputbuf
2015-12-29 12:26:46.48 spid25s (@p0 uniqueidentifier,@p1 uniqueidentifier,@p2 nvarchar(4000),@p3 uniqueidentifier,@p4 bit,@RETURN_VALUE int output)EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:26:46.48 spid25s resource-list
2015-12-29 12:26:46.48 spid25s pagelock fileid=1 pageid=133232 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockc6990f80 mode=U associatedObjectId=72057594041401344
2015-12-29 12:26:46.48 spid25s owner-list
2015-12-29 12:26:46.48 spid25s owner id=processe6022088 mode=U
2015-12-29 12:26:46.48 spid25s waiter-list
2015-12-29 12:26:46.48 spid25s waiter id=process816cbdc8 mode=U requestType=wait
2015-12-29 12:26:46.48 spid25s pagelock fileid=1 pageid=41279 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockbf917980 mode=U associatedObjectId=72057594041401344
2015-12-29 12:26:46.48 spid25s owner-list
2015-12-29 12:26:46.48 spid25s owner id=processe6022088 mode=U
2015-12-29 12:26:46.48 spid25s waiter-list
2015-12-29 12:26:46.48 spid25s waiter id=process841662c8 mode=U requestType=wait
2015-12-29 12:26:46.48 spid25s pagelock fileid=1 pageid=356574 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockca6ce880 mode=U associatedObjectId=72057594041401344
2015-12-29 12:26:46.48 spid25s owner-list
2015-12-29 12:26:46.48 spid25s waiter-list
2015-12-29 12:26:46.48 spid25s waiter id=processe6022088 mode=U requestType=wait
2015-12-29 12:26:46.48 spid25s pagelock fileid=1 pageid=356574 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockca6ce880 mode=U associatedObjectId=72057594041401344
2015-12-29 12:26:46.48 spid25s owner-list
2015-12-29 12:26:46.48 spid25s owner id=process54fdc8 mode=U
2015-12-29 12:26:46.48 spid25s waiter-list
2015-12-29 12:26:46.48 spid25s waiter id=processa7103dc8 mode=U requestType=wait
2015-12-29 12:26:46.48 spid25s exchangeEvent id=Pipee6a1c580 WaitType=e_waitPipeGetRow nodeId=9
2015-12-29 12:26:46.48 spid25s owner-list
2015-12-29 12:26:46.48 spid25s owner id=process816cbdc8
2015-12-29 12:26:46.48 spid25s owner id=process841662c8
2015-12-29 12:26:46.48 spid25s waiter-list
2015-12-29 12:26:46.48 spid25s waiter id=process54fdc8
2015-12-29 12:26:51.47 spid19s deadlock-list
2015-12-29 12:26:51.47 spid19s deadlock victim=processe6022088
2015-12-29 12:26:51.47 spid19s process-list
2015-12-29 12:26:51.47 spid19s process id=processe6022088 taskpriority=0 logused=0 waitresource=PAGE: 99:1:55591 waittime=4959 ownerId=291888 transactionname=UPDATE lasttranstarted=2015-12-29T12:26:41.480 XDES=0x80049d20 lockMode=U schedulerid=2 kpid=15648 status=suspended spid=96 sbid=2 ecid=1 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:26:41.437 lastbatchcompleted=2015-12-29T12:26:41.427 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=291888 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:26:51.47 spid19s executionStack
2015-12-29 12:26:51.47 spid19s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:26:51.47 spid19s update ede
2015-12-29 12:26:51.47 spid19s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:26:51.47 spid19s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:26:51.47 spid19s from dbo.tSomeTableEntity ede
2015-12-29 12:26:51.47 spid19s where ede.pk = @pkSomeTableEntity
2015-12-29 12:26:51.47 spid19s --and (
2015-12-29 12:26:51.47 spid19s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:26:51.47 spid19s -- or
2015-12-29 12:26:51.47 spid19s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:26:51.47 spid19s -- );
2015-12-29 12:26:51.47 spid19s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:26:51.47 spid19s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:26:51.47 spid19s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:26:51.47 spid19s unknown
2015-12-29 12:26:51.47 spid19s inputbuf
2015-12-29 12:26:51.47 spid19s process id=processe6022748 taskpriority=0 logused=0 waitresource=PAGE: 99:1:55591 waittime=8090 ownerId=293094 transactionname=UPDATE lasttranstarted=2015-12-29T12:26:43.367 XDES=0x810f3620 lockMode=U schedulerid=2 kpid=15848 status=suspended spid=101 sbid=2 ecid=3 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:26:43.367 lastbatchcompleted=2015-12-29T12:26:43.310 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=293094 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:26:51.47 spid19s executionStack
2015-12-29 12:26:51.47 spid19s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:26:51.47 spid19s update ede
2015-12-29 12:26:51.47 spid19s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:26:51.47 spid19s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:26:51.47 spid19s from dbo.tSomeTableEntity ede
2015-12-29 12:26:51.47 spid19s where ede.pk = @pkSomeTableEntity
2015-12-29 12:26:51.47 spid19s --and (
2015-12-29 12:26:51.47 spid19s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:26:51.47 spid19s -- or
2015-12-29 12:26:51.47 spid19s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:26:51.47 spid19s -- );
2015-12-29 12:26:51.47 spid19s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:26:51.47 spid19s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:26:51.47 spid19s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:26:51.47 spid19s unknown
2015-12-29 12:26:51.47 spid19s inputbuf
2015-12-29 12:26:51.47 spid19s process id=processa7102508 taskpriority=0 logused=10000 waittime=4797 schedulerid=3 kpid=15704 status=suspended spid=96 sbid=2 ecid=0 priority=0 trancount=2 lastbatchstarted=2015-12-29T12:26:41.437 lastbatchcompleted=2015-12-29T12:26:41.427 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 loginname=sql2008 isolationlevel=read committed (2) xactid=291888 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:26:51.47 spid19s executionStack
2015-12-29 12:26:51.47 spid19s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:26:51.47 spid19s update ede
2015-12-29 12:26:51.47 spid19s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:26:51.47 spid19s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:26:51.47 spid19s from dbo.tSomeTableEntity ede
2015-12-29 12:26:51.47 spid19s where ede.pk = @pkSomeTableEntity
2015-12-29 12:26:51.47 spid19s --and (
2015-12-29 12:26:51.47 spid19s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:26:51.47 spid19s -- or
2015-12-29 12:26:51.47 spid19s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:26:51.47 spid19s -- );
2015-12-29 12:26:51.47 spid19s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:26:51.47 spid19s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:26:51.47 spid19s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:26:51.47 spid19s unknown
2015-12-29 12:26:51.47 spid19s inputbuf
2015-12-29 12:26:51.47 spid19s (@p0 uniqueidentifier,@p1 uniqueidentifier,@p2 nvarchar(4000),@p3 uniqueidentifier,@p4 bit,@RETURN_VALUE int output)EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:26:51.47 spid19s resource-list
2015-12-29 12:26:51.47 spid19s pagelock fileid=1 pageid=55591 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockce305680 mode=U associatedObjectId=72057594041401344
2015-12-29 12:26:51.47 spid19s owner-list
2015-12-29 12:26:51.47 spid19s waiter-list
2015-12-29 12:26:51.47 spid19s waiter id=processe6022088 mode=U requestType=wait
2015-12-29 12:26:51.48 spid19s pagelock fileid=1 pageid=55591 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockce305680 mode=U associatedObjectId=72057594041401344
2015-12-29 12:26:51.48 spid19s owner-list
2015-12-29 12:26:51.48 spid19s owner id=processa7102508 mode=U
2015-12-29 12:26:51.48 spid19s waiter-list
2015-12-29 12:26:51.48 spid19s waiter id=processe6022748 mode=U requestType=wait
2015-12-29 12:26:51.48 spid19s exchangeEvent id=Pipee3d5a580 WaitType=e_waitPipeGetRow nodeId=9
2015-12-29 12:26:51.48 spid19s owner-list
2015-12-29 12:26:51.48 spid19s owner id=processe6022088
2015-12-29 12:26:51.48 spid19s waiter-list
2015-12-29 12:26:51.48 spid19s waiter id=processa7102508
2015-12-29 12:28:12.73 spid20s deadlock-list
2015-12-29 12:28:12.73 spid20s deadlock victim=processa7103948
2015-12-29 12:28:12.73 spid20s process-list
2015-12-29 12:28:12.73 spid20s process id=processa7103948 taskpriority=0 logused=0 waitresource=PAGE: 99:1:356574 waittime=1839 ownerId=314396 transactionname=UPDATE lasttranstarted=2015-12-29T12:28:10.920 XDES=0x803b7620 lockMode=U schedulerid=3 kpid=16352 status=suspended spid=68 sbid=2 ecid=4 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:28:10.873 lastbatchcompleted=2015-12-29T12:28:10.863 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=314396 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:28:12.73 spid20s executionStack
2015-12-29 12:28:12.73 spid20s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:28:12.73 spid20s update ede
2015-12-29 12:28:12.73 spid20s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:28:12.73 spid20s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:28:12.73 spid20s from dbo.tSomeTableEntity ede
2015-12-29 12:28:12.73 spid20s where ede.pk = @pkSomeTableEntity
2015-12-29 12:28:12.73 spid20s --and (
2015-12-29 12:28:12.73 spid20s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:28:12.73 spid20s -- or
2015-12-29 12:28:12.73 spid20s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:28:12.73 spid20s -- );
2015-12-29 12:28:12.73 spid20s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:28:12.73 spid20s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:28:12.73 spid20s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:28:12.73 spid20s unknown
2015-12-29 12:28:12.73 spid20s inputbuf
2015-12-29 12:28:12.73 spid20s process id=processe6022088 taskpriority=0 logused=0 waitresource=PAGE: 99:1:133232 waittime=1736 ownerId=314400 transactionname=UPDATE lasttranstarted=2015-12-29T12:28:10.920 XDES=0x925f1940 lockMode=U schedulerid=2 kpid=15648 status=suspended spid=93 sbid=2 ecid=3 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:28:10.913 lastbatchcompleted=2015-12-29T12:28:10.913 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=314400 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:28:12.73 spid20s executionStack
2015-12-29 12:28:12.73 spid20s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:28:12.73 spid20s update ede
2015-12-29 12:28:12.73 spid20s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:28:12.73 spid20s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:28:12.73 spid20s from dbo.tSomeTableEntity ede
2015-12-29 12:28:12.73 spid20s where ede.pk = @pkSomeTableEntity
2015-12-29 12:28:12.73 spid20s --and (
2015-12-29 12:28:12.73 spid20s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:28:12.73 spid20s -- or
2015-12-29 12:28:12.73 spid20s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:28:12.73 spid20s -- );
2015-12-29 12:28:12.73 spid20s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:28:12.73 spid20s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:28:12.73 spid20s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:28:12.73 spid20s unknown
2015-12-29 12:28:12.73 spid20s inputbuf
2015-12-29 12:28:12.73 spid20s process id=process816cb048 taskpriority=0 logused=0 waitresource=PAGE: 99:1:133232 waittime=1842 ownerId=314400 transactionname=UPDATE lasttranstarted=2015-12-29T12:28:10.920 XDES=0x80bc1c50 lockMode=U schedulerid=4 kpid=15968 status=suspended spid=93 sbid=2 ecid=2 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:28:10.913 lastbatchcompleted=2015-12-29T12:28:10.913 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=314400 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:28:12.73 spid20s executionStack
2015-12-29 12:28:12.73 spid20s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:28:12.73 spid20s update ede
2015-12-29 12:28:12.73 spid20s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:28:12.73 spid20s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:28:12.73 spid20s from dbo.tSomeTableEntity ede
2015-12-29 12:28:12.73 spid20s where ede.pk = @pkSomeTableEntity
2015-12-29 12:28:12.73 spid20s --and (
2015-12-29 12:28:12.73 spid20s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:28:12.73 spid20s -- or
2015-12-29 12:28:12.73 spid20s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:28:12.73 spid20s -- );
2015-12-29 12:28:12.73 spid20s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:28:12.73 spid20s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:28:12.73 spid20s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:28:12.73 spid20s unknown
2015-12-29 12:28:12.73 spid20s inputbuf
2015-12-29 12:28:12.73 spid20s process id=processe6022508 taskpriority=0 logused=0 waitresource=PAGE: 99:1:356574 waittime=1737 ownerId=314396 transactionname=UPDATE lasttranstarted=2015-12-29T12:28:10.920 XDES=0x80049d20 lockMode=U schedulerid=2 kpid=15848 status=suspended spid=68 sbid=2 ecid=3 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:28:10.873 lastbatchcompleted=2015-12-29T12:28:10.863 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=314396 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:28:12.73 spid20s executionStack
2015-12-29 12:28:12.73 spid20s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:28:12.73 spid20s update ede
2015-12-29 12:28:12.73 spid20s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:28:12.73 spid20s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:28:12.73 spid20s from dbo.tSomeTableEntity ede
2015-12-29 12:28:12.73 spid20s where ede.pk = @pkSomeTableEntity
2015-12-29 12:28:12.73 spid20s --and (
2015-12-29 12:28:12.73 spid20s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:28:12.73 spid20s -- or
2015-12-29 12:28:12.73 spid20s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:28:12.73 spid20s -- );
2015-12-29 12:28:12.73 spid20s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:28:12.73 spid20s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:28:12.73 spid20s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:28:12.73 spid20s unknown
2015-12-29 12:28:12.73 spid20s inputbuf
2015-12-29 12:28:12.73 spid20s process id=processe60222c8 taskpriority=0 logused=10000 waittime=1543 schedulerid=2 kpid=3020 status=suspended spid=93 sbid=2 ecid=0 priority=0 trancount=2 lastbatchstarted=2015-12-29T12:28:10.913 lastbatchcompleted=2015-12-29T12:28:10.913 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 loginname=sql2008 isolationlevel=read committed (2) xactid=314400 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:28:12.73 spid20s executionStack
2015-12-29 12:28:12.73 spid20s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:28:12.73 spid20s update ede
2015-12-29 12:28:12.73 spid20s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:28:12.73 spid20s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:28:12.73 spid20s from dbo.tSomeTableEntity ede
2015-12-29 12:28:12.73 spid20s where ede.pk = @pkSomeTableEntity
2015-12-29 12:28:12.73 spid20s --and (
2015-12-29 12:28:12.73 spid20s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:28:12.73 spid20s -- or
2015-12-29 12:28:12.73 spid20s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:28:12.73 spid20s -- );
2015-12-29 12:28:12.73 spid20s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:28:12.73 spid20s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:28:12.73 spid20s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:28:12.73 spid20s unknown
2015-12-29 12:28:12.73 spid20s inputbuf
2015-12-29 12:28:12.73 spid20s (@p0 uniqueidentifier,@p1 uniqueidentifier,@p2 nvarchar(4000),@p3 uniqueidentifier,@p4 bit,@RETURN_VALUE int output)EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:28:12.73 spid20s resource-list
2015-12-29 12:28:12.73 spid20s pagelock fileid=1 pageid=356574 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockc912d100 mode=U associatedObjectId=72057594041401344
2015-12-29 12:28:12.73 spid20s owner-list
2015-12-29 12:28:12.73 spid20s owner id=processe60222c8 mode=U
2015-12-29 12:28:12.73 spid20s waiter-list
2015-12-29 12:28:12.73 spid20s waiter id=processa7103948 mode=U requestType=wait
2015-12-29 12:28:12.73 spid20s pagelock fileid=1 pageid=133232 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockd10afc00 mode=U associatedObjectId=72057594041401344
2015-12-29 12:28:12.73 spid20s owner-list
2015-12-29 12:28:12.73 spid20s waiter-list
2015-12-29 12:28:12.73 spid20s waiter id=processe6022088 mode=U requestType=wait
2015-12-29 12:28:12.73 spid20s pagelock fileid=1 pageid=133232 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockd10afc00 mode=U associatedObjectId=72057594041401344
2015-12-29 12:28:12.73 spid20s owner-list
2015-12-29 12:28:12.73 spid20s owner id=processe6022508 mode=U
2015-12-29 12:28:12.73 spid20s waiter-list
2015-12-29 12:28:12.73 spid20s waiter id=process816cb048 mode=U requestType=wait
2015-12-29 12:28:12.73 spid20s pagelock fileid=1 pageid=356574 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockc912d100 mode=U associatedObjectId=72057594041401344
2015-12-29 12:28:12.73 spid20s owner-list
2015-12-29 12:28:12.73 spid20s waiter-list
2015-12-29 12:28:12.73 spid20s waiter id=processe6022508 mode=U requestType=wait
2015-12-29 12:28:12.73 spid20s exchangeEvent id=Pipee52ac580 WaitType=e_waitPipeGetRow nodeId=9
2015-12-29 12:28:12.73 spid20s owner-list
2015-12-29 12:28:12.73 spid20s owner id=processe6022088
2015-12-29 12:28:12.73 spid20s owner id=process816cb048
2015-12-29 12:28:12.73 spid20s waiter-list
2015-12-29 12:28:12.73 spid20s waiter id=processe60222c8
2015-12-29 12:28:17.74 spid25s deadlock-list
2015-12-29 12:28:17.74 spid25s deadlock victim=process816cb048
2015-12-29 12:28:17.74 spid25s process-list
2015-12-29 12:28:17.74 spid25s process id=process816cb048 taskpriority=0 logused=0 waitresource=PAGE: 99:1:133232 waittime=2155 ownerId=316054 transactionname=UPDATE lasttranstarted=2015-12-29T12:28:15.563 XDES=0x80bc19e0 lockMode=U schedulerid=4 kpid=7200 status=suspended spid=96 sbid=2 ecid=2 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:28:15.430 lastbatchcompleted=2015-12-29T12:28:15.420 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=316054 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:28:17.74 spid25s executionStack
2015-12-29 12:28:17.74 spid25s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:28:17.74 spid25s update ede
2015-12-29 12:28:17.74 spid25s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:28:17.74 spid25s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:28:17.74 spid25s from dbo.tSomeTableEntity ede
2015-12-29 12:28:17.74 spid25s where ede.pk = @pkSomeTableEntity
2015-12-29 12:28:17.74 spid25s --and (
2015-12-29 12:28:17.74 spid25s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:28:17.74 spid25s -- or
2015-12-29 12:28:17.74 spid25s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:28:17.74 spid25s -- );
2015-12-29 12:28:17.74 spid25s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:28:17.74 spid25s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:28:17.74 spid25s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:28:17.74 spid25s unknown
2015-12-29 12:28:17.74 spid25s inputbuf
2015-12-29 12:28:17.74 spid25s process id=processe6022bc8 taskpriority=0 logused=0 waitresource=PAGE: 99:1:133232 waittime=2146 ownerId=316046 transactionname=UPDATE lasttranstarted=2015-12-29T12:28:15.420 XDES=0x80049d20 lockMode=U schedulerid=2 kpid=3020 status=suspended spid=91 sbid=2 ecid=3 priority=0 trancount=0 lastbatchstarted=2015-12-29T12:28:15.290 lastbatchcompleted=2015-12-29T12:28:15.283 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 isolationlevel=read committed (2) xactid=316046 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:28:17.74 spid25s executionStack
2015-12-29 12:28:17.74 spid25s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:28:17.74 spid25s update ede
2015-12-29 12:28:17.74 spid25s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:28:17.74 spid25s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:28:17.74 spid25s from dbo.tSomeTableEntity ede
2015-12-29 12:28:17.74 spid25s where ede.pk = @pkSomeTableEntity
2015-12-29 12:28:17.74 spid25s --and (
2015-12-29 12:28:17.74 spid25s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:28:17.74 spid25s -- or
2015-12-29 12:28:17.74 spid25s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:28:17.74 spid25s -- );
2015-12-29 12:28:17.74 spid25s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:28:17.74 spid25s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:28:17.74 spid25s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:28:17.74 spid25s unknown
2015-12-29 12:28:17.74 spid25s inputbuf
2015-12-29 12:28:17.74 spid25s process id=processd4d048 taskpriority=0 logused=10000 waittime=1981 schedulerid=4 kpid=15864 status=suspended spid=91 sbid=2 ecid=0 priority=0 trancount=2 lastbatchstarted=2015-12-29T12:28:15.290 lastbatchcompleted=2015-12-29T12:28:15.283 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=16788 loginname=sql2008 isolationlevel=read committed (2) xactid=316046 currentdb=99 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 12:28:17.74 spid25s executionStack
2015-12-29 12:28:17.74 spid25s frame procname=someDB_life_test.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300630063a935550072cb0068a500000100000000000000
2015-12-29 12:28:17.74 spid25s update ede
2015-12-29 12:28:17.74 spid25s set ede.fkSomeLinkToEntity = coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity),
2015-12-29 12:28:17.74 spid25s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 12:28:17.74 spid25s from dbo.tSomeTableEntity ede
2015-12-29 12:28:17.74 spid25s where ede.pk = @pkSomeTableEntity
2015-12-29 12:28:17.74 spid25s --and (
2015-12-29 12:28:17.74 spid25s -- ede.fkSomeLinkToEntity <> coalesce(@fkSomeLinkToEntity, ede.fkSomeLinkToEntity)
2015-12-29 12:28:17.74 spid25s -- or
2015-12-29 12:28:17.74 spid25s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 12:28:17.74 spid25s -- );
2015-12-29 12:28:17.74 spid25s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01006300763e4526b0f1a0b3000000000000000000000000
2015-12-29 12:28:17.74 spid25s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:28:17.74 spid25s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 12:28:17.74 spid25s unknown
2015-12-29 12:28:17.74 spid25s inputbuf
2015-12-29 12:28:17.74 spid25s (@p0 uniqueidentifier,@p1 uniqueidentifier,@p2 nvarchar(4000),@p3 uniqueidentifier,@p4 bit,@RETURN_VALUE int output)EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkSomeLinkToEntity = @p3, @deleted = @p4
2015-12-29 12:28:17.74 spid25s resource-list
2015-12-29 12:28:17.74 spid25s pagelock fileid=1 pageid=133232 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockc3f6b900 mode=U associatedObjectId=72057594041401344
2015-12-29 12:28:17.74 spid25s owner-list
2015-12-29 12:28:17.74 spid25s owner id=processd4d048 mode=U
2015-12-29 12:28:17.74 spid25s waiter-list
2015-12-29 12:28:17.74 spid25s waiter id=process816cb048 mode=U requestType=wait
2015-12-29 12:28:17.74 spid25s pagelock fileid=1 pageid=133232 dbid=99 objectname=someDB_life_test.dbo.tSomeTableEntity id=lockc3f6b900 mode=U associatedObjectId=72057594041401344
2015-12-29 12:28:17.74 spid25s owner-list
2015-12-29 12:28:17.74 spid25s waiter-list
2015-12-29 12:28:17.74 spid25s waiter id=processe6022bc8 mode=U requestType=wait
2015-12-29 12:28:17.74 spid25s exchangeEvent id=Pipedf7f8580 WaitType=e_waitPipeGetRow nodeId=9
2015-12-29 12:28:17.74 spid25s owner-list
2015-12-29 12:28:17.74 spid25s owner id=processe6022bc8
2015-12-29 12:28:17.74 spid25s waiter-list
2015-12-29 12:28:17.74 spid25s waiter id=processd4d048




Но после того как я тупо проверку сделал перед апдейтом
if @pkSomeTableEntity is null return

уже не воспроизводится.

Ну и вообще уже переписал хранимку на merge/
Тут больше теперь вопрос принципа понять почему и по факту всегда решал Дед Локи и не понимал кучу надписей в этих графах. Увидел запросы, понял что тормозит и потом "до следующего раза".
29 дек 15, 15:17    [18623354]     Ответить | Цитировать Сообщить модератору
 Re: Deadlock чтение графа, как узнать параметры и причины блокировки при апдейте по PK  [new]
invm
Member

Откуда: Москва
Сообщений: 9413
NIIIK,

У вас intra-query parallelism deadlock.
29 дек 15, 15:57    [18623529]     Ответить | Цитировать Сообщить модератору
 Re: Deadlock чтение графа, как узнать параметры и причины блокировки при апдейте по PK  [new]
NIIIK
Member

Откуда: Россия, Ростовская область, г. Таганрог
Сообщений: 1295
invm,

я такой дедлок встречал только в сложном Селекте и без maxdop 1

Вы уверены что такой у меня??? Я вроде сейча смотрю, жертвы не вижу (victim), но те кто тестили и запускали говорили что у них были Эксепшены (а при Интра-паралелизм вроде и нет такого).
29 дек 15, 17:21    [18623968]     Ответить | Цитировать Сообщить модератору
 Re: Deadlock чтение графа, как узнать параметры и причины блокировки при апдейте по PK  [new]
invm
Member

Откуда: Москва
Сообщений: 9413
NIIIK
Вы уверены что такой у меня???
Посмотрел внимательнее: да, не intra-query.
Но наличие
NIIIK
exchangeEvent id=Pipedf7f8580 WaitType=e_waitPipeGetRow nodeId=9
говорит о параллельном выполнении запроса в одном из процессов.
29 дек 15, 18:08    [18624192]     Ответить | Цитировать Сообщить модератору
 Re: Deadlock чтение графа, как узнать параметры и причины блокировки при апдейте по PK  [new]
churupaha
Member

Откуда: Краснодар
Сообщений: 1015
NIIIK,

а какая у вас версия сервера? выдергнули бы xml-граф из xe-сессии system_health. а то пока распарсишь эту черно-серую партянку
29 дек 15, 18:16    [18624220]     Ответить | Цитировать Сообщить модератору
 Re: Deadlock чтение графа, как узнать параметры и причины блокировки при апдейте по PK  [new]
NIIIK
Member

Откуда: Россия, Ростовская область, г. Таганрог
Сообщений: 1295
churupaha,

Там где тестировал (я урывками на эту задачу)

SQL Server
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)



Вот
выдергнули бы xml-граф из xe-сессии system_health

Это про что?

Кстати, на другой базе на этом же сервере (вполне позвможно другой уровень изоляции) они получили "с жертвой" на старом коде

+

2015-12-29 18:05:14.59 spid32s deadlock victim=process54f708
2015-12-29 18:05:14.59 spid32s process-list
2015-12-29 18:05:14.59 spid32s process id=process54f708 taskpriority=5 logused=0 waitresource=PAGE: 82:1:352643 waittime=1473 ownerId=7614950 transactionname=user_transaction lasttranstarted=2015-12-29T18:05:07.627 XDES=0x8c978080 lockMode=U schedulerid=1 kpid=23256 status=suspended spid=64 sbid=2 ecid=2 priority=-5 trancount=0 lastbatchstarted=2015-12-29T18:05:07.680 lastbatchcompleted=2015-12-29T18:05:07.630 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=17944 isolationlevel=read uncommitted (1) xactid=7614950 currentdb=82 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 18:05:14.59 spid32s executionStack
2015-12-29 18:05:14.59 spid32s frame procname=someDB_life.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300520063a935550072cb0068a500000100000000000000
2015-12-29 18:05:14.59 spid32s update ede
2015-12-29 18:05:14.59 spid32s set ede.fkLinkToEntity = coalesce(@fkLinkToEntity, ede.fkLinkToEntity),
2015-12-29 18:05:14.59 spid32s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 18:05:14.59 spid32s from dbo.tSomeTableEntity ede
2015-12-29 18:05:14.59 spid32s where ede.pk = @pkSomeTableEntity
2015-12-29 18:05:14.59 spid32s --and (
2015-12-29 18:05:14.59 spid32s -- ede.fkLinkToEntity <> coalesce(@fkLinkToEntity, ede.fkLinkToEntity)
2015-12-29 18:05:14.59 spid32s -- or
2015-12-29 18:05:14.59 spid32s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 18:05:14.59 spid32s -- );
2015-12-29 18:05:14.59 spid32s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01005200763e4526a095a4de000000000000000000000000
2015-12-29 18:05:14.59 spid32s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkLinkToEntity = @p3, @deleted = @p4
2015-12-29 18:05:14.59 spid32s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 18:05:14.59 spid32s unknown
2015-12-29 18:05:14.59 spid32s inputbuf
2015-12-29 18:05:14.59 spid32s process id=process54f048 taskpriority=5 logused=4792 waitresource=PAGE: 82:1:55685 waittime=1396 ownerId=7608327 transactionname=user_transaction lasttranstarted=2015-12-29T18:04:12.223 XDES=0x92f716c0 lockMode=U schedulerid=1 kpid=7200 status=suspended spid=102 sbid=2 ecid=3 priority=-5 trancount=0 lastbatchstarted=2015-12-29T18:05:13.213 lastbatchcompleted=2015-12-29T18:05:13.210 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=17944 isolationlevel=read uncommitted (1) xactid=7608327 currentdb=82 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 18:05:14.59 spid32s executionStack
2015-12-29 18:05:14.60 spid32s frame procname=someDB_life.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300520063a935550072cb0068a500000100000000000000
2015-12-29 18:05:14.60 spid32s update ede
2015-12-29 18:05:14.60 spid32s set ede.fkLinkToEntity = coalesce(@fkLinkToEntity, ede.fkLinkToEntity),
2015-12-29 18:05:14.60 spid32s ede.deleted = coalesce(@deleted, ede.deleted)
2015-12-29 18:05:14.60 spid32s from dbo.tSomeTableEntity ede
2015-12-29 18:05:14.60 spid32s where ede.pk = @pkSomeTableEntity
2015-12-29 18:05:14.60 spid32s --and (
2015-12-29 18:05:14.60 spid32s -- ede.fkLinkToEntity <> coalesce(@fkLinkToEntity, ede.fkLinkToEntity)
2015-12-29 18:05:14.60 spid32s -- or
2015-12-29 18:05:14.60 spid32s -- ede.deleted <> coalesce(@deleted, ede.deleted)
2015-12-29 18:05:14.60 spid32s -- );
2015-12-29 18:05:14.60 spid32s frame procname=adhoc line=1 stmtstart=232 sqlhandle=0x01005200763e4526a095a4de000000000000000000000000
2015-12-29 18:05:14.60 spid32s EXEC @RETURN_VALUE = [dbo].[spSomeTableEntity] @fkEntity = @p0, @fkAttribute = @p1, @synAttribute = @p2, @fkLinkToEntity = @p3, @deleted = @p4
2015-12-29 18:05:14.60 spid32s frame procname=unknown line=1 sqlhandle=0x000000000000000000000000000000000000000000000000
2015-12-29 18:05:14.60 spid32s unknown
2015-12-29 18:05:14.60 spid32s inputbuf
2015-12-29 18:05:14.60 spid32s process id=process129c1c988 taskpriority=5 logused=4792 waitresource=PAGE: 82:1:55591 waittime=1396 ownerId=7608327 transactionname=user_transaction lasttranstarted=2015-12-29T18:04:12.223 XDES=0xc26b3d70 lockMode=U schedulerid=4 kpid=25460 status=suspended spid=102 sbid=2 ecid=2 priority=-5 trancount=0 lastbatchstarted=2015-12-29T18:05:13.213 lastbatchcompleted=2015-12-29T18:05:13.210 clientapp=.Net SqlClient Data Provider hostname=WIN-IIS hostpid=17944 isolationlevel=read uncommitted (1) xactid=7608327 currentdb=82 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
2015-12-29 18:05:14.60 spid32s executionStack
2015-12-29 18:05:14.60 spid32s frame procname=someDB_life.dbo.spSomeTableEntity line=102 stmtstart=4830 stmtend=5656 sqlhandle=0x0300520063a935550072cb0068a500000100000000000000

29 дек 15, 18:30    [18624271]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить