1st graph

<deadlock-list> <deadlock victim="processc25828"> <process-list> <process id="processbbf048" taskpriority="0" logused="28892" waitresource="PAGE: 14:1:340676" waittime="3984" ownerId="484691527" transactionname="ius" lasttranstarted="2010-09-30T10:03:22.080" XDES="0xa50f54c0" lockMode="IX" schedulerid="1" kpid="10288" status="suspended" spid="65" sbid="0" ecid="0" priority="0" transcount="4" lastbatchstarted="2010-09-30T10:03:22.080" lastbatchcompleted="2010-09-30T10:03:22.080" clientapp="CBS" hostname="DAWEBP100" hostpid="8976" loginname="DMZ\xProdCBS" isolationlevel="read committed (2)" xactid="484691527" currentdb="14" lockTimeout="4294967295" clientoption1="673316896" clientoption2="128056"> <executionStack> <frame procname="TsiCbs.dbo.tsi_sp_object_insert" line="28" stmtstart="1170" stmtend="1358" sqlhandle="0x03000e00f578a27585a8a500169c00000100000000000000"> UPDATE tsi_t_objects SET NRight = NRight + 2 WHERE NRight >= @parentRight </frame> <frame procname="TsiCbs.dbo.tsi_tg_object_insert" line="17" stmtstart="760" stmtend="826" sqlhandle="0x03000e00e823327aa6b3a500169c00000000000000000000"> EXEC tsi_sp_object_insert @id </frame> <frame procname="TsiCbs.dbo.tsi_sp_insert_update_object" line="21" stmtstart="862" stmtend="1350" sqlhandle="0x03000e002e9d967693a8a500169c00000100000000000000"> INSERT INTO tsi_t_objects(Parent_Fk, [Name], ObjectType_Fk, ModifiedDate, ModifiedBy_Fk, SortOrder, [Guid], ExternalId) VALUES(@parentId, @name, @objectTypeId, GETUTCDATE(), @modifiedById, @sortOrder, NEWID(), @externalId) </frame> <frame procname="TsiCbs.dbo.x_sp_insert_update_person" line="39" stmtstart="1988" stmtend="2244" sqlhandle="0x03000e00f704cd06c7572001b79c00000100000000000000"> EXEC tsi_sp_insert_update_object @id OUTPUT, @parentId, @name, @objectTypeId, @modifiedById, @sortOrder, @externalId </frame> <frame procname="TsiCbs.dbo.x_sp_insert_update_user" line="59" stmtstart="3232" stmtend="3934" sqlhandle="0x03000e001646bc1cd7572001b79c00000100000000000000"> EXEC x_sp_insert_update_person @id OUTPUT, @parentId, @name, @objectTypeId, @modifiedById, @sortOrder, @firstName, @lastName, @email, @email2, @middleInitial, @middleName, @phoneNumber1, @phoneType1Id, @phoneNumber2, @phoneType2Id, @phoneNumber3, @phoneType3Id, @phoneNumber4, @phoneType4Id, @primaryPhoneNumber, @externalId </frame> </executionStack> <inputbuf> Proc [Database Id = 14 Object Id = 482100758] </inputbuf> </process> <process id="processc25828" taskpriority="0" logused="0" waitresource="PAGE: 14:1:340909" waittime="3984" ownerId="484691470" transactionname="SELECT" lasttranstarted="2010-09-30T10:03:22.017" XDES="0x802e2f88" lockMode="S" schedulerid="2" kpid="38908" status="suspended" spid="60" sbid="0" ecid="0" priority="0" transcount="0" lastbatchstarted="2010-09-30T10:03:22.017" lastbatchcompleted="2010-09-30T10:03:22.017" clientapp="CBS" hostname="DAWEBP100" hostpid="8976" loginname="DMZ\xProdCBS" isolationlevel="read committed (2)" xactid="484691470" currentdb="14" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"> <executionStack> <frame procname="TsiCbs.dbo.tsi_sp_list_securing_groups" line="8" stmtstart="366" stmtend="706" sqlhandle="0x03000e008a1acf2fafada500169c00000100000000000000"> SELECT * FROM tsi_v_secured s INNER JOIN tsi_f_get_object_permissions(@userId) op ON op.OwnedId = s.SecurityGroupId WHERE SecuredId = @securedId AND PermissionId = </frame> </executionStack> <inputbuf> Proc [Database Id = 14 Object Id = 802101898] </inputbuf> </process> </process-list> <resource-list> <pagelock fileid="1" pageid="340909" dbid="14" objectname="TsiCbs.dbo.tsi_t_objects" id="lock979d9980" mode="IX" associatedObjectId="72057594529382400"> <owner-list> <owner id="processbbf048" mode="IX"/> </owner-list> <waiter-list> <waiter id="processc25828" mode="S" requestType="wait"/> </waiter-list> </pagelock> <pagelock fileid="1" pageid="340676" dbid="14" objectname="TsiCbs.dbo.tsi_t_objects" id="locka6139580" mode="SIU" associatedObjectId="72057594529382400"> <owner-list> <owner id="processc25828" mode="S"/> </owner-list> <waiter-list> <waiter id="processbbf048" mode="IX" requestType="convert"/> </waiter-list> </pagelock> </resource-list> </deadlock> </deadlock-list>

2nd Graph

<deadlock-list> <deadlock victim="processbbeef8"> <process-list> <process id="processbbeef8" taskpriority="0" logused="0" waitresource="KEY: 14:72057594529382400 (aa00a25ad511)" waittime="7843" ownerId="484691567" transactionname="SELECT" lasttranstarted="2010-09-30T10:03:23.220" XDES="0xc8220868" lockMode="S" schedulerid="1" kpid="30564" status="suspended" spid="76" sbid="0" ecid="0" priority="0" transcount="0" lastbatchstarted="2010-09-30T10:03:23.220" lastbatchcompleted="2010-09-30T10:03:23.220" clientapp="CBS" hostname="DAWEBP100" hostpid="8976" loginname="DMZ\xProdCBS" isolationlevel="read committed (2)" xactid="484691567" currentdb="14" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"> <executionStack> <frame procname="TsiCbs.dbo.x_sp_get_user_by_username" line="4" stmtstart="164" sqlhandle="0x03000e00a5436923ffaba500169c00000100000000000000"> SELECT * FROM x_v_users WHERE Username = @username; </frame> </executionStack> <inputbuf> Proc [Database Id = 14 Object Id = 594101157] </inputbuf> </process> <process id="processbbf048" taskpriority="0" logused="669676" waitresource="KEY: 14:72057594529382400 (bf00f1ccfd51)" waittime="4734" ownerId="484691527" transactionname="ius" lasttranstarted="2010-09-30T10:03:22.080" XDES="0xa50f54c0" lockMode="X" schedulerid="1" kpid="10288" status="suspended" spid="65" sbid="0" ecid="0" priority="0" transcount="4" lastbatchstarted="2010-09-30T10:03:22.080" lastbatchcompleted="2010-09-30T10:03:22.080" clientapp="CBS" hostname="DAWEBP100" hostpid="8976" loginname="DMZ\xProdCBS" isolationlevel="read committed (2)" xactid="484691527" currentdb="14" lockTimeout="4294967295" clientoption1="673316896" clientoption2="128056"> <executionStack> <frame procname="TsiCbs.dbo.tsi_sp_object_insert" line="28" stmtstart="1170" stmtend="1358" sqlhandle="0x03000e00f578a27585a8a500169c00000100000000000000"> UPDATE tsi_t_objects SET NRight = NRight + 2 WHERE NRight >= @parentRight </frame> <frame procname="TsiCbs.dbo.tsi_tg_object_insert" line="17" stmtstart="760" stmtend="826" sqlhandle="0x03000e00e823327aa6b3a500169c00000000000000000000"> EXEC tsi_sp_object_insert @id </frame> <frame procname="TsiCbs.dbo.tsi_sp_insert_update_object" line="21" stmtstart="862" stmtend="1350" sqlhandle="0x03000e002e9d967693a8a500169c00000100000000000000"> INSERT INTO tsi_t_objects(Parent_Fk, [Name], ObjectType_Fk, ModifiedDate, ModifiedBy_Fk, SortOrder, [Guid], ExternalId) VALUES(@parentId, @name, @objectTypeId, GETUTCDATE(), @modifiedById, @sortOrder, NEWID(), @externalId) </frame> <frame procname="TsiCbs.dbo.x_sp_insert_update_person" line="39" stmtstart="1988" stmtend="2244" sqlhandle="0x03000e00f704cd06c7572001b79c00000100000000000000"> EXEC tsi_sp_insert_update_object @id OUTPUT, @parentId, @name, @objectTypeId, @modifiedById, @sortOrder, @externalId </frame> <frame procname="TsiCbs.dbo.x_sp_insert_update_user" line="59" stmtstart="3232" stmtend="3934" sqlhandle="0x03000e001646bc1cd7572001b79c00000100000000000000"> EXEC x_sp_insert_update_person @id OUTPUT, @parentId, @name, @objectTypeId, @modifiedById, @sortOrder, @firstName, @lastName, @email, @email2, @middleInitial, @middleName, @phoneNumber1, @phoneType1Id, @phoneNumber2, @phoneType2Id, @phoneNumber3, @phoneType3Id, @phoneNumber4, @phoneType4Id, @primaryPhoneNumber, @externalId </frame> </executionStack> <inputbuf> Proc [Database Id = 14 Object Id = 482100758] </inputbuf> </process> </process-list> <resource-list> <keylock hobtid="72057594529382400" dbid="14" objectname="TsiCbs.dbo.tsi_t_objects" indexname="PK_tsi_tLoginHierarchy" id="lock96828e80" mode="X" associatedObjectId="72057594529382400"> <owner-list> <owner id="processbbf048" mode="X"/> </owner-list> <waiter-list> <waiter id="processbbeef8" mode="S" requestType="wait"/> </waiter-list> </keylock> <keylock hobtid="72057594529382400" dbid="14" objectname="TsiCbs.dbo.tsi_t_objects" indexname="PK_tsi_tLoginHierarchy" id="locka5e72600" mode="U" associatedObjectId="72057594529382400"> <owner-list> <owner id="processbbeef8" mode="S"/> </owner-list> <waiter-list> <waiter id="processbbf048" mode="X" requestType="convert"/> </waiter-list> </keylock> </resource-list> </deadlock> </deadlock-list>