Deadlocks after index rebuild
-
We rebuilt a bunch of indexes that had avg_fragmentation_in_percent>30. Now we have 1 job that is consistently getting deadlocks and I'm trying to find the root cause. Attached is the event data xml file from the deadlock event. Any help on which direction to start looking is greatly appreciated. We are using 2016 sp 2.
<event name="xml_deadlock_report" package="sqlserver" timestamp="2025-03-04T15:16:17.973Z">
<data name="xml_report">
<value>
<deadlock>
<victim-list>
<victimProcess id="process22adf4b08c8" />
</victim-list>
<process-list>
<process id="process22adf4b08c8" taskpriority="0" logused="0" waitresource="PAGE: 7:1:7096497 " waittime="4436" ownerId="209795797" transactionname="SELECT" lasttranstarted="2025-03-04T10:16:00.697" XDES="0x22be1347a50" lockMode="S" schedulerid="16" kpid="21232" status="suspended" spid="81" sbid="0" ecid="87" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process2285d2028c8" taskpriority="0" logused="0" waitresource="PAGE: 7:1:7096497 " waittime="12952" ownerId="209801036" transactionname="INSERT" lasttranstarted="2025-03-04T10:16:04.973" XDES="0x22af9411a20" lockMode="S" schedulerid="11" kpid="16996" status="suspended" spid="83" sbid="0" ecid="22" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:04.973" lastbatchcompleted="2025-03-04T10:16:04.973" lastattention="1900-01-01T00:00:00.973" clientapp=".Net SqlClient Data Provider" hostname="WIN-6M4KB8581T7" hostpid="14836" isolationlevel="read committed (2)" xactid="209801036" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="530" sqlhandle="0x020000005b041f02cd460d9740b26d265956419aa62b98e50000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
insert into tshipment_glowforge select distinct shipmentid,0,1281,getdate(),null,null,0 from tordershipment os inner join torder o on o.orderid=os.orderid where o.programid=545 and o.sys_deleteflag=0 and shipmentid not in (select shipmentid from tshipment_glowforge) </inputbuf>
</process>
<process id="process22d7801d088" taskpriority="0" logused="4372" waitresource="OBJECT: 7:322360463:0 " waittime="14257" ownerId="209800844" transactionname="user_transaction" lasttranstarted="2025-03-04T10:16:03.670" XDES="0x22a707f2430" lockMode="IX" schedulerid="1" kpid="20656" status="suspended" spid="57" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2025-03-04T10:16:03.710" lastbatchcompleted="2025-03-04T10:16:03.710" lastattention="2025-03-04T10:15:30.787" clientapp=".Net SqlClient Data Provider" hostname="WIN-6M4KB8581T7" hostpid="7916" loginname="WIN-6M4KB8581T7\web_app_user" isolationlevel="read committed (2)" xactid="209800844" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
<executionStack>
<frame procname="EWMS_PILOT.dbo.uspInsertOrderDetail" line="35" stmtstart="1506" stmtend="3120" sqlhandle="0x030007005b0f7352fd7f8b0175ac000001000000000000000000000000000000000000000000000000000000">
INSERT INTO dbo.tOrderDetail
(
OrderID,
LineNumber,
WarehouseID,
CatalogID,
ContainerID,
ItemID,
Quantity,
InventoryTypeID,
IsFilled,
IsCritical,
sys_CreatedBy,
BackOrder ,
QuantityBackOrdered ,
IsOrderFromStorageOnly,
IsOrderFromNonOrdarableInventoryType,
LotNumber,
LocationId
)
VALUES (
@OrderID,
@LineNumber,
@WarehouseID,
@CatalogID,
@ContainerId,
@ItemId,
@Quantity,
@InventoryTypeID,
@IsFilled,
@IsCritical,
@sys_CreatedBy,
@IsBackOrder,
@QuantityBackOrdered,
@IsOrderFromStorageOnly,
@IsOrderFromNonOrdarableInventoryType,
@LotNumber,
@LocationId </frame>
</executionStack>
<inputbuf>
Proc [Database Id = 7 Object Id = 1383272283] </inputbuf>
</process>
<process id="process22d786b9468" taskpriority="0" logused="10000" waittime="4445" schedulerid="13" kpid="9808" status="suspended" spid="81" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" loginname="NT SERVICE\SQLSERVERAGENT" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process229117608c8" taskpriority="0" logused="10000" waittime="4435" schedulerid="1" kpid="10552" status="suspended" spid="81" sbid="0" ecid="127" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22830bc68c8" taskpriority="0" logused="10000" waittime="4435" schedulerid="1" kpid="18864" status="suspended" spid="81" sbid="0" ecid="35" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22736920ca8" taskpriority="0" logused="10000" waittime="4435" schedulerid="8" kpid="5684" status="suspended" spid="81" sbid="0" ecid="113" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22c9b21e108" taskpriority="0" logused="10000" waittime="4435" schedulerid="3" kpid="7604" status="suspended" spid="81" sbid="0" ecid="118" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process2283be69468" taskpriority="0" logused="10000" waittime="4435" schedulerid="4" kpid="2072" status="suspended" spid="81" sbid="0" ecid="117" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process2281aecdc28" taskpriority="0" logused="10000" waittime="4435" schedulerid="2" kpid="9380" status="suspended" spid="81" sbid="0" ecid="123" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process2291a8b1c28" taskpriority="0" logused="10000" waittime="4435" schedulerid="5" kpid="8920" status="suspended" spid="81" sbid="0" ecid="126" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22d69cf3088" taskpriority="0" logused="10000" waittime="4435" schedulerid="6" kpid="11832" status="suspended" spid="81" sbid="0" ecid="125" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22be5bae4e8" taskpriority="0" logused="10000" waittime="4435" schedulerid="7" kpid="9296" status="suspended" spid="81" sbid="0" ecid="121" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22724215088" taskpriority="0" logused="10000" waittime="4435" schedulerid="16" kpid="12788" status="suspended" spid="81" sbid="0" ecid="120" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process227054c24e8" taskpriority="0" logused="10000" waittime="4435" schedulerid="12" kpid="2056" status="suspended" spid="81" sbid="0" ecid="122" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22d786a9c28" taskpriority="0" logused="10000" waittime="4436" schedulerid="11" kpid="4336" status="suspended" spid="81" sbid="0" ecid="114" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22b89906108" taskpriority="0" logused="10000" waittime="4435" schedulerid="9" kpid="20644" status="suspended" spid="81" sbid="0" ecid="119" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process226c6d848c8" taskpriority="0" logused="10000" waittime="4435" schedulerid="14" kpid="20940" status="suspended" spid="81" sbid="0" ecid="128" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process2290782cca8" taskpriority="0" logused="10000" waittime="4435" schedulerid="10" kpid="12988" status="suspended" spid="81" sbid="0" ecid="124" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22990862ca8" taskpriority="0" logused="10000" waittime="4435" schedulerid="13" kpid="20368" status="suspended" spid="81" sbid="0" ecid="115" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22b1cb56108" taskpriority="0" logused="10000" waittime="4435" schedulerid="15" kpid="1220" status="suspended" spid="81" sbid="0" ecid="116" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22821a0c8c8" taskpriority="0" logused="10000" waittime="4435" schedulerid="2" kpid="7936" status="suspended" spid="81" sbid="0" ecid="32" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process2282a1c3088" taskpriority="0" logused="10000" waittime="4435" schedulerid="3" kpid="12136" status="suspended" spid="81" sbid="0" ecid="33" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process2281a424108" taskpriority="0" logused="10000" waittime="4435" schedulerid="4" kpid="20068" status="suspended" spid="81" sbid="0" ecid="34" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process228dd0be4e8" taskpriority="0" logused="10000" waittime="4435" schedulerid="5" kpid="15108" status="suspended" spid="81" sbid="0" ecid="34" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process2299da2c4e8" taskpriority="0" logused="10000" waittime="4435" schedulerid="6" kpid="10024" status="suspended" spid="81" sbid="0" ecid="35" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22d69586ca8" taskpriority="0" logused="10000" waittime="4435" schedulerid="7" kpid="21052" status="suspended" spid="81" sbid="0" ecid="33" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process227e8de24e8" taskpriority="0" logused="10000" waittime="4435" schedulerid="8" kpid="15740" status="suspended" spid="81" sbid="0" ecid="31" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process2280ae2a8c8" taskpriority="0" logused="10000" waittime="4435" schedulerid="9" kpid="516" status="suspended" spid="81" sbid="0" ecid="37" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process227923408c8" taskpriority="0" logused="10000" waittime="4435" schedulerid="10" kpid="21220" status="suspended" spid="81" sbid="0" ecid="36" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process2285d203468" taskpriority="0" logused="10000" waittime="4435" schedulerid="11" kpid="11712" status="suspended" spid="81" sbid="0" ecid="37" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22d276fa108" taskpriority="0" logused="10000" waittime="4435" schedulerid="12" kpid="13980" status="suspended" spid="81" sbid="0" ecid="39" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process2299cc7aca8" taskpriority="0" logused="10000" waittime="4436" schedulerid="14" kpid="17992" status="suspended" spid="81" sbid="0" ecid="36" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22adf4b1848" taskpriority="0" logused="10000" waittime="4436" schedulerid="16" kpid="16296" status="suspended" spid="81" sbid="0" ecid="38" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22bb2746ca8" taskpriority="0" logused="10000" waittime="4436" schedulerid="15" kpid="8972" status="suspended" spid="81" sbid="0" ecid="38" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
<process id="process22cf21f2108" taskpriority="0" logused="10000" waittime="4436" schedulerid="13" kpid="13320" status="suspended" spid="81" sbid="0" ecid="39" priority="0" trancount="0" lastbatchstarted="2025-03-04T10:16:00.697" lastbatchcompleted="2025-03-04T10:16:00.697" lastattention="1900-01-01T00:00:00.697" clientapp="Microsoft SQL Server" hostname="WIN-6M4KB8581T7" hostpid="20184" isolationlevel="read committed (2)" xactid="209795797" currentdb="7" currentdbname="EWMS_PILOT" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtend="3084" sqlhandle="0x020000001f7eed30197e36607a45a72b4e26839ce1fc41650000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SELECT distinct TOP 500 i.ItemID,ISNULL(ivt.Priority,99) Priority
FROM dbo.tItem I
INNER JOIN dbo.tProgramInventoryStatus pis ON i.InventoryStatusID =pis.ProgramInventoryStatusID
INNER JOIN tCatalog c on c.CatalogID=I.CatalogID
INNER JOIN tOrderDetail od on od.CatalogID=c.CatalogID AND (od.WarehouseID =i.WarehouseID OR od.WarehouseID IS NULL)
--INNER JOIN dbo.tBackOrderDetail bod ON bod.CatalogID=c.CatalogID AND (bod.WarehouseID =i.WarehouseID OR bod.WarehouseID IS NULL)
INNER JOIN dbo.tOrder o ON od.OrderID = o.OrderID
LEFT JOIN dbo.tOrderShipment os ON o.OrderID = os.OrderId
LEFT JOIN dbo.tShipment s ON os.ShipmentId = s.ShipmentID
INNER JOIN dbo.tLocation l ON i.LocationID =l.LocationID
INNER JOIN tLocationType lt on lt.LocationTypeID=l.LocationTypeID
INNER JOIN tInventoryType ivt on ivt.InventoryTypeID=i.InventoryTypeID
inner join tWarehouse w on w.WarehouseID=i.WarehouseID
WHERE i.sys_DeleteFlag =0 and pis.Code ='A' and (ivt.BackOrderable=1 or ivt.BackOrderable IS NULL or od.IsOrder </inputbuf>
</process>
</process-list>
<resource-list>
<pagelock fileid="1" pageid="7096497" dbid="7" subresource="FULL" objectname="EWMS_PILOT.dbo.tOrderShipment" id="lock227128de080" mode="IX" associatedObjectId="72060854535061504">
<owner-list>
<owner id="process2285d2028c8" mode="S" requestType="wait" />
</owner-list>
<waiter-list>
<waiter id="process22adf4b08c8" mode="S" requestType="wait" />
</waiter-list>
</pagelock>
<pagelock fileid="1" pageid="7096497" dbid="7" subresource="FULL" objectname="EWMS_PILOT.dbo.tOrderShipment" id="lock227128de080" mode="IX" associatedObjectId="72060854535061504">
<owner-list>
<owner id="process22d7801d088" mode="IX" />
</owner-list>
<waiter-list>
<waiter id="process2285d2028c8" mode="S" requestType="wait" />
</waiter-list>
</pagelock>
<objectlock lockPartition="0" objid="322360463" subresource="FULL" dbid="7" objectname="EWMS_PILOT.dbo.tOrderDetail" id="lock22716db0e80" mode="S" associatedObjectId="322360463">
<owner-list>
<owner id="process22d786b9468" mode="S" />
</owner-list>
<waiter-list>
<waiter id="process22d7801d088" mode="IX" requestType="wait" />
</waiter-list>
</objectlock>
<exchangeEvent id="Port22d72c57c00" WaitType="e_waitPortOpen" waiterType="Coordinator" nodeId="1" tid="0" ownerActivity="notYetOpened" waiterActivity="waitForAllOwnersToOpen">
<owner-list>
<owner id="process2281a424108" />
<owner id="process227e8de24e8" />
<owner id="process2282a1c3088" />
<owner id="process22821a0c8c8" />
<owner id="process22d69586ca8" />
<owner id="process22830bc68c8" />
<owner id="process228dd0be4e8" />
<owner id="process2299da2c4e8" />
<owner id="process2299cc7aca8" />
<owner id="process227923408c8" />
<owner id="process22adf4b1848" />
<owner id="process2280ae2a8c8" />
<owner id="process22d276fa108" />
<owner id="process2285d203468" />
<owner id="process22bb2746ca8" />
<owner id="process22cf21f2108" />
</owner-list>
<waiter-list>
<waiter id="process22d786b9468" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe22c29b1d280" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="56" tid="2" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process229117608c8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e324c80" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="6" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process22830bc68c8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Port22d72c56c00" WaitType="e_waitPortClose" waiterType="Consumer" nodeId="56" tid="1" ownerActivity="opened" waiterActivity="waitForAllOwnersToClose">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process22736920ca8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe22c29b1d380" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="56" tid="3" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process22c9b21e108" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe22c29b1d480" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="56" tid="4" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process2283be69468" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Port22d72c56c00" WaitType="e_waitPortClose" waiterType="Consumer" nodeId="56" tid="5" ownerActivity="opened" waiterActivity="waitForAllOwnersToClose">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process2281aecdc28" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Port22d72c56c00" WaitType="e_waitPortClose" waiterType="Consumer" nodeId="56" tid="6" ownerActivity="opened" waiterActivity="waitForAllOwnersToClose">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process2291a8b1c28" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe22c29b1d780" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="56" tid="7" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process22d69cf3088" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Port22d72c56c00" WaitType="e_waitPortClose" waiterType="Consumer" nodeId="56" tid="8" ownerActivity="opened" waiterActivity="waitForAllOwnersToClose">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process22be5bae4e8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Port22d72c56c00" WaitType="e_waitPortClose" waiterType="Consumer" nodeId="56" tid="9" ownerActivity="opened" waiterActivity="waitForAllOwnersToClose">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process22724215088" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe227f4078280" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="56" tid="10" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process227054c24e8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Port22d72c56c00" WaitType="e_waitPortClose" waiterType="Consumer" nodeId="56" tid="11" ownerActivity="opened" waiterActivity="waitForAllOwnersToClose">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process22d786a9c28" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Port22d72c56c00" WaitType="e_waitPortClose" waiterType="Consumer" nodeId="56" tid="12" ownerActivity="opened" waiterActivity="waitForAllOwnersToClose">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process22b89906108" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Port22d72c56c00" WaitType="e_waitPortClose" waiterType="Consumer" nodeId="56" tid="13" ownerActivity="opened" waiterActivity="waitForAllOwnersToClose">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process226c6d848c8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Port22d72c56c00" WaitType="e_waitPortClose" waiterType="Consumer" nodeId="56" tid="14" ownerActivity="opened" waiterActivity="waitForAllOwnersToClose">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process2290782cca8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Port22d72c56c00" WaitType="e_waitPortClose" waiterType="Consumer" nodeId="56" tid="15" ownerActivity="opened" waiterActivity="waitForAllOwnersToClose">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process22990862ca8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Port22d72c56c00" WaitType="e_waitPortClose" waiterType="Consumer" nodeId="56" tid="16" ownerActivity="opened" waiterActivity="waitForAllOwnersToClose">
<owner-list>
<owner id="process22adf4b08c8" />
</owner-list>
<waiter-list>
<waiter id="process22b1cb56108" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e324a80" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="4" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process22821a0c8c8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e324980" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="3" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process2282a1c3088" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e324780" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="1" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process2281a424108" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e324d80" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="7" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process228dd0be4e8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e324f00" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="8" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process2299da2c4e8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e324b80" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="5" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process22d69586ca8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e324880" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="2" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process227e8de24e8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e325300" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="12" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process2280ae2a8c8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e325100" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="10" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process227923408c8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e325500" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="14" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process2285d203468" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e325400" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="13" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process22d276fa108" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e325000" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="9" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process2299cc7aca8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e325200" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="11" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process22adf4b1848" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e325680" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="15" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process22bb2746ca8" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe2279e325780" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="9" tid="16" ownerActivity="sentData" waiterActivity="needMoreData" merging="false" spilling="false" waitingToClose="false">
<owner-list>
<owner id="process22736920ca8" />
<owner id="process229117608c8" />
<owner id="process22c9b21e108" />
<owner id="process2283be69468" />
<owner id="process2281aecdc28" />
<owner id="process2291a8b1c28" />
<owner id="process22d69cf3088" />
<owner id="process22be5bae4e8" />
<owner id="process22724215088" />
<owner id="process227054c24e8" />
<owner id="process22d786a9c28" />
<owner id="process22b89906108" />
<owner id="process226c6d848c8" />
<owner id="process2290782cca8" />
<owner id="process22990862ca8" />
<owner id="process22b1cb56108" />
</owner-list>
<waiter-list>
<waiter id="process22cf21f2108" />
</waiter-list>
</exchangeEvent>
</resource-list>
</deadlock>
</value>
</data>
</event> -
This was removed by the editor as SPAM
-
your deadlock graph xml is incomplete !
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Just updated with the complete xml.
-
Tools like Solarwinds SQL Sentry PlanExplorer (free) can help you analyse this situation !
It helps you narrow down the 2 tables that are to be addressed to solve the puzzle
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
For your deadlock graph to be usable, you need to remove:
<event name="xml_deadlock_report" package="sqlserver" timestamp="2025-03-04T15:16:17.973Z">
<data name="xml_report">
<value>
Keep the rest
Remove the bottom
</value>
</data>
</event>Then you can open the file using Plan Explorer and it will show you a great set of information to help you solve the case !
The replay feature can be of huge help !
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Will download and give it a try
-
I was able to get it working but I'm not sure I know how to analyze this chart/data to get something meaningful out of it.
- btork wrote:
We rebuilt a bunch of indexes that had avg_fragmentation_in_percent>30.
This will sound odd but you probably won't get much useful data from the deadlock data other than you're now suffering from massive highly contentious blocking resulting in deadlocks... all thanks to your index rebuilds.
Did you first prove beyond any reasonable doubt that the fragmentation was actually causing performance issues or did you just blindly follow the "Best Practices" that not only were never meant to be "Best Practices" ( https://www.sqlskills.com/blogs/paul/where-do-the-books-online-index-fragmentation-thresholds-come-from/ ) but are actually a worst practice?
Also, did the indexes have a FILL FACTOR and are the indexes all of the "Ever increasing" type or are they somewhat "random" in nature?
I suspect what has happened is your rebuild was done on indexes that have the default Fill Factor of "0", which is the same in all other resptects as "100", which means that no free space exists in the indexes after the index rebuilds and what you're getting now is a huge number of page splits from inserts and/or expansive updates. That crippled my server on the 18th of January. 2016. I have NOT done regular index maintenance since then and performance has been just fine. Rebuilding statistics is much more important and much more effective without causing the mess you're seeing now.
The same holds true for REORGANIZE whether or not you have a proper Fill Factor on an index that can take advantage of a Fill Factor or not. REORGANIZE does NOT "follow the Fill Factor" the way REBUILDs do.
As you've just found out, doing index maintenance incorrectly is far worse that not doing any index maintenance at all. The only thing that the deadlock graphs will tell you is that you have massive highly contentious blocking that is resulting in deadlocks.
You may have to do what I did way back in 2016... ride out the storm today and stop rebuilding those indexes without more serious knowledge of them.
And none of that is meant as a slam... a lot of people, including a younger me, have made the same mistake (and some never learn more after that and keep making the same mistake).
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
@jeff - a lot of this rings true with me and this situation. My real challenge is how do I move forward. Should I update the stats for the tables involved in this deadlock? Curious of your thoughts relating to your situation.
- btork wrote:
@Jeff - a lot of this rings true with me and this situation. My real challenge is how do I move forward. Should I update the stats for the tables involved in this deadlock? Curious of your thoughts relating to your situation.
The deadlocking should subside once enough pages splits have occurred to make some room. If you know for sure which tables are deadlocking, you could try another index rebuild but with a Fill Factor but, unless you've done a pretty deep study to know that it's actually going to work, I'd be tempted to just wait it out.
Do you happen to know what the page density for these tables was prior to doing the index rebuilds?
A rebuild of statistics probably won't help because the REBUILDs also did an update of statistics. That, not withstanding, rebuilding the statistics will not cause the same harm that the index rebuilds have. And, for sure, don't even think about using REORGANIZE on these tables.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
It's also possible that you were missing critical index(es) that were forcing full scans of the table. Every issue is not necessarily always exactly the same as one that happened 9 years ago.
Unfortunately, rebuilding the indexes on the table will typically clear all the missing_index_* view data from SQL Server, so if you didn't save it earlier -- and it's extremely doubtful that you did -- it's gone now. I'd suggest capturing missing_index info periodically so that you can review it later. That can also help you adjust existing indexes, for example, by adding INCLUDEd column(s) to an existing index(es).
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply