DeadLocks and exchangeEvent

  • We are getting a lot of deadlocks in our web application w/SQL 2005 backend. I am trying to get a handle on what is being reported as the specific reason and, if possible, get an explanation that I can use to provide a direction forward for my non-technical managers .

    The exact reasons for the deadlocks are not obvious. The code has been reduced to single record updates and indexes are being used. There are questions about the indexes that are in place for the tables involved. I willl ask about that later. 1222 tracing has been turned on so we get the deadlock info in the SQL event log.

    Here is the situation:

    We've figured out a pattern, a common situation and a variant that occurs a lot. I will try and simplify the explanation and protect the identities of the innocent (poor tables and stored procedures). I will also post a simplified version of the deadlock data.

    Code explanation: A common deadlock situation is where there are multiple instances of 2 different procedures that are performing updates on the same table. The 2 procedures are actually updating the exact same fields, but ACTION_UPD uses criteria "where RecordID = @RecordID" and ORDER_UPD uses criteria "where WkstnID = @WkstnID". As you will see in the deadlock info, there are 2 instances of ACTION_UPD involved in the deadlock action and 9 instances of the ORDER_UPD.

    Simplified deadlock info:

    deadlock-list

    deadlock victim=process8de3e8

    process-list

    process84ab68

    taskpriority=0 logused=7860 waitresource=PAGE: 6:3:1158397 waittime=4921 ownerId=2095798641 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:46.940 XDES=0x1401bdf8 lockMode=U schedulerid=1 kpid=11916 status=suspended spid=52 sbid=0 ecid=5 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:44.297 lastbatchcompleted=2012-12-11T09:43:44.297 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=3732 isolationlevel=read uncommitted (1) xactid=2095798641 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    executionStack frame procname=ACTION_UPD, plus triggers for DateLastChanged and POUpdateDate

    process84b108

    taskpriority=0 logused=6320 waitresource=PAGE: 6:1:34110 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x77164560 lockMode=U schedulerid=1 kpid=10916 status=suspended spid=80 sbid=0 ecid=6 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    executionStack frame procname=ORDER_UPD, plus triggers for datelastchanged

    process8d9978

    taskpriority=0 logused=20004 waittime=4921 schedulerid=2 kpid=9056 status=suspended spid=52 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2012-12-11T09:43:44.297 lastbatchcompleted=2012-12-11T09:43:44.297 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=3732 loginname=BART_User isolationlevel=read uncommitted (1) xactid=2095798641 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    executionStack frame procname=ACTION_UPD, plus triggers for DateLastChanged and POUpdateDate

    process8d9c48

    taskpriority=0 logused=6320 waitresource=PAGE: 6:1:42765 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x1401fb70 lockMode=U schedulerid=2 kpid=9864 status=suspended spid=80 sbid=0 ecid=8 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    executionStack frame procname=ORDER_UPD, plus triggers for datelastchanged

    process8de3e8**

    taskpriority=0 logused=6320 waitresource=PAGE: 6:3:715812 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x14023ac0 lockMode=U schedulerid=3 kpid=5924 status=suspended spid=80 sbid=0 ecid=1 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    executionStack frame procname=ORDER_UPD, plus triggers for datelastchanged

    processb84d48

    taskpriority=0 logused=6320 waitresource=PAGE: 6:1:23991 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x14027e10 lockMode=U schedulerid=4 kpid=12056 status=suspended spid=80 sbid=0 ecid=2 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    executionStack frame procname=ORDER_UPD, plus triggers for datelastchanged

    processc1b3d8

    taskpriority=0 logused=6320 waitresource=PAGE: 6:1:39479 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x5f596240 lockMode=U schedulerid=5 kpid=6192 status=suspended spid=80 sbid=0 ecid=7 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    executionStack frame procname=ORDER_UPD, plus triggers for datelastchanged

    processdb1f18

    taskpriority=0 logused=6320 waitresource=PAGE: 6:1:39599 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x1402fbe8 lockMode=U schedulerid=6 kpid=11096 status=suspended spid=80 sbid=0 ecid=5 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    executionStack frame procname=ORDER_UPD, plus triggers for datelastchanged

    processdc63e8

    taskpriority=0 logused=6320 waitresource=PAGE: 6:1:23752 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x20197e08 lockMode=U schedulerid=7 kpid=9300 status=suspended spid=80 sbid=0 ecid=4 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    executionStack frame procname=ORDER_UPD, plus triggers for datelastchanged

    processdc76a8

    taskpriority=0 logused=20004 waittime=5609 schedulerid=7 kpid=10548 status=suspended spid=80 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 loginname=BART_User isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    executionStack frame procname=ORDER_UPD, plus triggers for datelastchanged

    processedcd48

    taskpriority=0 logused=6320 waitresource=PAGE: 6:3:77 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x140378c0 lockMode=U schedulerid=8 kpid=8020 status=suspended spid=80 sbid=0 ecid=3 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    executionStack frame procname=ORDER_UPD, plus triggers for datelastchanged

    resource-list

    pagelock fileid=3 pageid=77 dbid=6 objectname=ORDERS id=lock1c4ddf80 mode=U associatedObjectId=72057603290365952

    Owner id=process8d9978 mode=U <<

    owner id=process8d9978 mode=U <<

    Waiter id=processedcd48 mode=U requestType=wait

    exchangeEvent id=port1413cf00 nodeId=4

    owner event=e_waitNone type=producer id=process8de3e8 **

    owner event=e_waitNone type=producer id=processedcd48

    owner event=e_waitNone type=producer id=processdc63e8

    owner event=e_waitNone type=producer id=processb84d48

    owner event=e_waitNone type=producer id=processdb1f18

    owner event=e_waitNone type=producer id=process84b108

    owner event=e_waitNone type=producer id=processc1b3d8

    owner event=e_waitNone type=producer id=process8d9c48

    waiter event=e_waitPipeGetRow type=consumer id=processdc76a8 @@

    pagelock fileid=3 pageid=1158397 dbid=6 objectname=ORDERS id=lock2d6f9880 mode=IX associatedObjectId=72057603290365952

    Owner id=processdc76a8 mode=IX @@

    waiter id=process84ab68 mode=U requestType=wait ##

    pagelock fileid=1 pageid=34110 dbid=6 objectname=ORDERS id=lock60682d80 mode=U associatedObjectId=72057603290365952

    owner id=process84ab68 mode=U ##

    waiter id=process84b108 mode=U requestType=wait

    pagelock fileid=1 pageid=23752 dbid=6 objectname=ORDERS id=lock4ceef880 mode=U associatedObjectId=72057603290365952

    Owner id=process8d9978 mode=U <<

    waiter id=processdc63e8 mode=U requestType=wait

    pagelock fileid=1 pageid=39599 dbid=6 objectname=ORDERS id=lock530a5ac0 mode=U associatedObjectId=72057603290365952

    owner id=process8d9978 mode=U<<

    owner id=process8d9978 mode=U<<

    waiter id=processdb1f18 mode=U requestType=wait

    pagelock fileid=1 pageid=39479 dbid=6 objectname=ORDERS id=lock557e8c80 mode=U associatedObjectId=72057603290365952

    owner id=process8d9978 mode=U <<

    owner id=process8d9978 mode=U

    waiter id=processc1b3d8 mode=U requestType=wait

    pagelock fileid=1 pageid=42765 dbid=6 objectname=ORDERS id=lock58220c00 mode=U associatedObjectId=72057603290365952

    owner id=process84ab68 mode=U ##

    waiter id=process8d9c48 mode=U requestType=wait

    pagelock fileid=1 pageid=23991 dbid=6 objectname=ORDERS id=lock5b2e6e80 mode=U associatedObjectId=72057603290365952

    owner id=process8d9978 mode=U <<

    waiter id=processb84d48 mode=U requestType=wait

    pagelock fileid=3 pageid=715812 dbid=6 objectname=ORDERS id=lock617a0cc0 mode=U associatedObjectId=72057603290365952

    owner id=process8d9978 mode=U <<

    waiter id=process8de3e8 mode=U requestType=wait **

    exchangeEvent id=port1413d300 nodeId=4

    owner event=e_waitNone type=producer id=process84ab68 ##

    waiter event=e_waitPipeGetRow type=consumer id=process8d9978 <<

    Deadlock Notes:

    I've marked the processes I think are involved with 2 special characters in the resource list. ** indicates the deadlock victim and others involved with <<, ##, @@.

    The associatedObjectId=72057603290365952 in the resource list is the clustered index on the Orders table.

    Questions:

    I find it odd that the deadlock victim was the first in a list of owners of an exchangeEvent, rather than a pagelock and the spids and sbids of the same procedures are the same. The bit of research I have done indicates problems with parallelism or a resource issue, rather than a missing index, which is what I have seen as a common resolution.

    Am I on the right track?

    Is is possible to confirm whether insufficient resources for the load, say memory, CPUs, or storage, or MAXDOP or other setting in the server config is to blame?

    The index situation I mentioned earlier on the Orders table is this: a clusted index, which I mentioned above, then 21 non-clusted indexes on various fields in the Orders table. These were apparently created over the years to resolve some performance issue on reports. Running the usage stats queries does show a few with low usage. The overall situation with these indexes is that probably 18 or 19 of these indexes contain the fields that are updated by the procedures involved in the deadlock, so almost all of these indexes are updated by each update operation. There is a plan being discussed to evaluate and consolidate the indexes, as a matter of "table optimization" - meaning we noticed this when we started working with this issue, but see this as a "best practices" situation. Would this necessarily be the cause or at least making the deadlock issue worse by having to update all those indexes upon update of the table?

    In the variant of this situation that I mentioned earlier, the deadlock victim is the first listed owner in an exchangeEvent AND an owner of a pagelock.

    All help towards a better understanding of this issue is appreciated.

  • Can you post the entire deadlock graph please? By the looks of it, you've simplified out info that I need to see what's happening.

    Can you also post the table definition and all index definitions (on the Orders table)?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Well, I was hoping I could avoid putting the whole thing up here. I tried to include everything but the code. There is already a separate plan to re-evaluate and re-apply the indexes. I would like to avoid posting all 22 of them, if possible.

    From the Event Log:

    2012-12-11 09:43:52.95 spid17s deadlock-list

    2012-12-11 09:43:52.95 spid17s deadlock victim=process8de3e8

    2012-12-11 09:43:52.95 spid17s process-list

    2012-12-11 09:43:52.95 spid17s process id=process84ab68 taskpriority=0 logused=7860 waitresource=PAGE: 6:3:1158397 waittime=4921 ownerId=2095798641 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:46.940 XDES=0x1401bdf8 lockMode=U schedulerid=1 kpid=11916 status=suspended spid=52 sbid=0 ecid=5 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:44.297 lastbatchcompleted=2012-12-11T09:43:44.297 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=3732 isolationlevel=read uncommitted (1) xactid=2095798641 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:43:52.95 spid17s executionStack

    2012-12-11 09:43:52.95 spid17s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:43:52.95 spid17s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:43:52.95 spid17s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.95 spid17s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:43:52.95 spid17s frame procname=BART.dbo.Upd_Po_Update_Date line=6 stmtstart=220 stmtend=536 sqlhandle=0x03000600e42911567bcd7000df9d00000000000000000000

    2012-12-11 09:43:52.95 spid17s UPDATE BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.95 spid17s SET PoUpdateDate = getdate()

    2012-12-11 09:43:52.95 spid17s FROM inserted, BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.95 spid17s WHERE BART_V3_TBL_ORDERS.WorkstationOID = Inserted.WorkstationOID

    2012-12-11 09:43:52.95 spid17s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_ACTION_UPD line=405 stmtstart=26314 stmtend=28188 sqlhandle=0x03000600c45d59684202610194a000000100000000000000

    2012-12-11 09:43:52.95 spid17s UPDATE BART_V3_TBL_Orders

    2012-12-11 09:43:52.95 spid17s SET

    2012-12-11 09:43:52.95 spid17s OrderedByLogin = '',

    2012-12-11 09:43:52.95 spid17s HardwareSKU = '',

    2012-12-11 09:43:52.95 spid17s InstallSKU = '',

    2012-12-11 09:43:52.95 spid17s DeinstallSKU = '',

    2012-12-11 09:43:52.95 spid17s OrderType = '',

    2012-12-11 09:43:52.95 spid17s Platform = '',

    2012-12-11 09:43:52.95 spid17s OrderStatus = 'N',

    2012-12-11 09:43:52.95 spid17s OrderDate = NULL,

    2012-12-11 09:43:52.95 spid17s ImageSKU = '',

    2012-12-11 09:43:52.95 spid17s OrderID = '',

    2012-12-11 09:43:52.95 spid17s OrderIDP = '',

    2012-12-11 09:43:52.95 spid17s LOB = '',

    2012-12-11 09:43:52.95 spid17s SubmittedByLogin = '',

    2012-12-11 09:43:52.95 spid17s SubmittedDate = NULL,

    2012-12-11 09:43:52.95 spid17s SubmittedToCOGDate = NULL,

    2012-12-11 09:43:52.95 spid17s AvailableOrders = 1,

    2012-12-11 09:43:52.95 spid17s AvailableMachines = 1,

    2012-12-11 09:43:52.95 spid17s POnumber = '',

    2012-12-11 09:43:52.95 spid17s POdate = NULL,

    2012-12-11 09:43:52.95 spid17s COGclerk = '',

    2012-12-11 09:43:52.95 spid17s SVCnumber = '',

    2012-12-11 09:43:52.95 spid17s DELLnumber = '',

    2012-12-11 09:43:52.95 spid17s PoUpdateSource = '',

    2012-12-11 09:43:52.95 spid17s --Trigger updates this: PoUpdateDate = NULL,

    2012-12-11 09:43:52.95 spid17s COGclerkAssigned = '',

    2012-12-11 09:43:52.95 spid17s TrackingInfo = 'N',

    2012-12-11 09:43:52.95 spid17s DeliveryInstructions = '',

    2012-12-11 09:43:52.95 spid17s BusinessJustification = '',

    2012-12-11 09:43:52.95 spid17s PreOrderHWBundle = '',

    2012-12-11 09:43:52.95 spid17s PreOrderOn = NULL,

    2012-12-11 09:43:52.95 spid17s PreOrderBy = '',

    2012-12-11 09:43:52.95 spid17s BudgetSource = '',

    2012-12-11 09:43:52.95 spid17s BudgetCompany = '',

    2012-12-11 09:43:52.95 spid17s BudgetCostCenter = '',

    2012-12-11 09:43:52.95 spid17s BudgetCOCCType = '',

    2012-12-11 09:43:52.95 spid17s InitiativeNumber = '',

    2012-12-11 09:43:52.95 spid17s RNumber = '',

    2012-12-11 09:43:52.95 spid17s ShipTo = '',

    2012-12-11 09:43:52.95 spid17s CountryID = NULL

    2012-12-11 09:43:52.95 spid17s WHERE bart_v3_tbl_orders.trackingnumber = @FROM_TrackingNumber

    2012-12-11 09:43:52.95 spid17s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_QUEUE_UPD line=32 stmtstart=1694 stmtend=1866 sqlhandle=0x0300060058c22d35ec526600679d00000100000000000000

    2012-12-11 09:43:52.95 spid17s EXEC BART_SP_REFRESH_PRMOVE_ACTION_UPD @FROM_TRACKINGNUMBER, @TO_TRACKINGNUMBER

    2012-12-11 09:43:52.95 spid17s inputbuf

    2012-12-11 09:43:52.95 spid17s process id=process84b108 taskpriority=0 logused=6320 waitresource=PAGE: 6:1:34110 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x77164560 lockMode=U schedulerid=1 kpid=10916 status=suspended spid=80 sbid=0 ecid=6 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:43:52.95 spid17s executionStack

    2012-12-11 09:43:52.95 spid17s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:43:52.95 spid17s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:43:52.95 spid17s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.95 spid17s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:43:52.95 spid17s frame procname=BART.dbo.BART_SP_PROCESS_ORDER_UPD line=71 stmtstart=5554 stmtend=8368 sqlhandle=0x030006001601c27115125c011da000000100000000000000

    2012-12-11 09:43:52.95 spid17s UPDATE BART_V3_TBL_Orders WITH (ROWLOCK)

    2012-12-11 09:43:52.95 spid17s SET

    2012-12-11 09:43:52.95 spid17s OrderIDP = @orderidp,

    2012-12-11 09:43:52.95 spid17s OrderedByLogin = @orderedbylogin,

    2012-12-11 09:43:52.95 spid17s HardwareSKU = @hardwaresku,

    2012-12-11 09:43:52.95 spid17s InstallSKU = @installsku,

    2012-12-11 09:43:52.95 spid17s DeinstallSKU = @deinstallsku,

    2012-12-11 09:43:52.95 spid17s OrderType = @ordertype,

    2012-12-11 09:43:52.95 spid17s OrderStatus = 'O',

    2012-12-11 09:43:52.95 spid17s OrderDate = @orderdate,

    2012-12-11 09:43:52.95 spid17s ImageSKU = @imagesku,

    2012-12-11 09:43:52.95 spid17s Platform = @imagesku,

    2012-12-11 09:43:52.95 spid17s ImageSKU_Justification = @imagejustification,

    2012-12-11 09:43:52.95 spid17s OrderID = @fullorderid,

    2012-12-11 09:43:52.95 spid17s LOB = @lobname,

    2012-12-11 09:43:52.95 spid17s SubmittedToLogin = @submittedtologin,

    2012-12-11 09:43:52.95 spid17s ShipTo = @shipto,

    2012-12-11 09:43:52.95 spid17s AvailableOrders = '0',

    2012-12-11 09:43:52.95 spid17s AvailableMachines = '0',

    2012-12-11 09:43:52.95 spid17s HP_Installation = @hpinstall,

    2012-12-11 09:43:52.95 spid17s DisposalSKUQuantity = @disposalskuqty,

    2012-12-11 09:43:52.95 spid17s ExpediteDelivery = @expeditedelivery,

    2012-12-11 09:43:52.95 spid17s DeliveryInstructions = @deliveryinstructions,

    2012-12-11 09:43:52.95 spid17s eRequestNbr = @erequestnumber,

    2012-12-11 09:43:52.95 spid17s PAR_TCMS_Nbr = @partcmsnbr,

    2012-12-11 09:43:52.95 spid17s BusinessJustification = @businessjustific

    2012-12-11 09:43:52.95 spid17s inputbuf

    2012-12-11 09:43:52.95 spid17s process id=process8d9978 taskpriority=0 logused=20004 waittime=4921 schedulerid=2 kpid=9056 status=suspended spid=52 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2012-12-11T09:43:44.297 lastbatchcompleted=2012-12-11T09:43:44.297 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=3732 loginname=BART_User isolationlevel=read uncommitted (1) xactid=2095798641 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:43:52.95 spid17s executionStack

    2012-12-11 09:43:52.95 spid17s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:43:52.95 spid17s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:43:52.95 spid17s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.95 spid17s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:43:52.95 spid17s frame procname=BART.dbo.Upd_Po_Update_Date line=6 stmtstart=220 stmtend=536 sqlhandle=0x03000600e42911567bcd7000df9d00000000000000000000

    2012-12-11 09:43:52.95 spid17s UPDATE BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.95 spid17s SET PoUpdateDate = getdate()

    2012-12-11 09:43:52.95 spid17s FROM inserted, BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.95 spid17s WHERE BART_V3_TBL_ORDERS.WorkstationOID = Inserted.WorkstationOID

    2012-12-11 09:43:52.95 spid17s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_ACTION_UPD line=405 stmtstart=26314 stmtend=28188 sqlhandle=0x03000600c45d59684202610194a000000100000000000000

    2012-12-11 09:43:52.95 spid17s UPDATE BART_V3_TBL_Orders

    2012-12-11 09:43:52.95 spid17s SET

    2012-12-11 09:43:52.95 spid17s OrderedByLogin = '',

    2012-12-11 09:43:52.95 spid17s HardwareSKU = '',

    2012-12-11 09:43:52.95 spid17s InstallSKU = '',

    2012-12-11 09:43:52.96 spid17s DeinstallSKU = '',

    2012-12-11 09:43:52.96 spid17s OrderType = '',

    2012-12-11 09:43:52.96 spid17s Platform = '',

    2012-12-11 09:43:52.96 spid17s OrderStatus = 'N',

    2012-12-11 09:43:52.96 spid17s OrderDate = NULL,

    2012-12-11 09:43:52.96 spid17s ImageSKU = '',

    2012-12-11 09:43:52.96 spid17s OrderID = '',

    2012-12-11 09:43:52.96 spid17s OrderIDP = '',

    2012-12-11 09:43:52.96 spid17s LOB = '',

    2012-12-11 09:43:52.96 spid17s SubmittedByLogin = '',

    2012-12-11 09:43:52.96 spid17s SubmittedDate = NULL,

    2012-12-11 09:43:52.96 spid17s SubmittedToCOGDate = NULL,

    2012-12-11 09:43:52.96 spid17s AvailableOrders = 1,

    2012-12-11 09:43:52.96 spid17s AvailableMachines = 1,

    2012-12-11 09:43:52.96 spid17s POnumber = '',

    2012-12-11 09:43:52.96 spid17s POdate = NULL,

    2012-12-11 09:43:52.96 spid17s COGclerk = '',

    2012-12-11 09:43:52.96 spid17s SVCnumber = '',

    2012-12-11 09:43:52.96 spid17s DELLnumber = '',

    2012-12-11 09:43:52.96 spid17s PoUpdateSource = '',

    2012-12-11 09:43:52.96 spid17s --Trigger updates this: PoUpdateDate = NULL,

    2012-12-11 09:43:52.96 spid17s COGclerkAssigned = '',

    2012-12-11 09:43:52.96 spid17s TrackingInfo = 'N',

    2012-12-11 09:43:52.96 spid17s DeliveryInstructions = '',

    2012-12-11 09:43:52.96 spid17s BusinessJustification = '',

    2012-12-11 09:43:52.96 spid17s PreOrderHWBundle = '',

    2012-12-11 09:43:52.96 spid17s PreOrderOn = NULL,

    2012-12-11 09:43:52.96 spid17s PreOrderBy = '',

    2012-12-11 09:43:52.96 spid17s BudgetSource = '',

    2012-12-11 09:43:52.96 spid17s BudgetCompany = '',

    2012-12-11 09:43:52.96 spid17s BudgetCostCenter = '',

    2012-12-11 09:43:52.96 spid17s BudgetCOCCType = '',

    2012-12-11 09:43:52.96 spid17s InitiativeNumber = '',

    2012-12-11 09:43:52.96 spid17s RNumber = '',

    2012-12-11 09:43:52.96 spid17s ShipTo = '',

    2012-12-11 09:43:52.96 spid17s CountryID = NULL

    2012-12-11 09:43:52.96 spid17s WHERE bart_v3_tbl_orders.trackingnumber = @FROM_TrackingNumber

    2012-12-11 09:43:52.96 spid17s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_QUEUE_UPD line=32 stmtstart=1694 stmtend=1866 sqlhandle=0x0300060058c22d35ec526600679d00000100000000000000

    2012-12-11 09:43:52.96 spid17s EXEC BART_SP_REFRESH_PRMOVE_ACTION_UPD @FROM_TRACKINGNUMBER, @TO_TRACKINGNUMBER

    2012-12-11 09:43:52.96 spid17s inputbuf

    2012-12-11 09:43:52.96 spid17s Proc [Database Id = 6 Object Id = 892191320]

    2012-12-11 09:43:52.96 spid17s process id=process8d9c48 taskpriority=0 logused=6320 waitresource=PAGE: 6:1:42765 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x1401fb70 lockMode=U schedulerid=2 kpid=9864 status=suspended spid=80 sbid=0 ecid=8 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:43:52.96 spid17s executionStack

    2012-12-11 09:43:52.96 spid17s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:43:52.96 spid17s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:43:52.96 spid17s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.96 spid17s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:43:52.96 spid17s frame procname=BART.dbo.BART_SP_PROCESS_ORDER_UPD line=71 stmtstart=5554 stmtend=8368 sqlhandle=0x030006001601c27115125c011da000000100000000000000

    2012-12-11 09:43:52.96 spid17s UPDATE BART_V3_TBL_Orders WITH (ROWLOCK)

    2012-12-11 09:43:52.96 spid17s SET

    2012-12-11 09:43:52.96 spid17s OrderIDP = @orderidp,

    2012-12-11 09:43:52.96 spid17s OrderedByLogin = @orderedbylogin,

    2012-12-11 09:43:52.96 spid17s HardwareSKU = @hardwaresku,

    2012-12-11 09:43:52.96 spid17s InstallSKU = @installsku,

    2012-12-11 09:43:52.96 spid17s DeinstallSKU = @deinstallsku,

    2012-12-11 09:43:52.96 spid17s OrderType = @ordertype,

    2012-12-11 09:43:52.96 spid17s OrderStatus = 'O',

    2012-12-11 09:43:52.96 spid17s OrderDate = @orderdate,

    2012-12-11 09:43:52.96 spid17s ImageSKU = @imagesku,

    2012-12-11 09:43:52.96 spid17s Platform = @imagesku,

    2012-12-11 09:43:52.96 spid17s ImageSKU_Justification = @imagejustification,

    2012-12-11 09:43:52.96 spid17s OrderID = @fullorderid,

    2012-12-11 09:43:52.96 spid17s LOB = @lobname,

    2012-12-11 09:43:52.96 spid17s SubmittedToLogin = @submittedtologin,

    2012-12-11 09:43:52.96 spid17s ShipTo = @shipto,

    2012-12-11 09:43:52.96 spid17s AvailableOrders = '0',

    2012-12-11 09:43:52.96 spid17s AvailableMachines = '0',

    2012-12-11 09:43:52.96 spid17s HP_Installation = @hpinstall,

    2012-12-11 09:43:52.96 spid17s DisposalSKUQuantity = @disposalskuqty,

    2012-12-11 09:43:52.96 spid17s ExpediteDelivery = @expeditedelivery,

    2012-12-11 09:43:52.96 spid17s DeliveryInstructions = @deliveryinstructions,

    2012-12-11 09:43:52.96 spid17s eRequestNbr = @erequestnumber,

    2012-12-11 09:43:52.96 spid17s PAR_TCMS_Nbr = @partcmsnbr,

    2012-12-11 09:43:52.96 spid17s BusinessJustification = @businessjustific

    2012-12-11 09:43:52.96 spid17s inputbuf

    2012-12-11 09:43:52.96 spid17s process id=process8de3e8 taskpriority=0 logused=6320 waitresource=PAGE: 6:3:715812 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x14023ac0 lockMode=U schedulerid=3 kpid=5924 status=suspended spid=80 sbid=0 ecid=1 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:43:52.96 spid17s executionStack

    2012-12-11 09:43:52.96 spid17s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:43:52.96 spid17s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:43:52.96 spid17s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.96 spid17s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:43:52.96 spid17s frame procname=BART.dbo.BART_SP_PROCESS_ORDER_UPD line=71 stmtstart=5554 stmtend=8368 sqlhandle=0x030006001601c27115125c011da000000100000000000000

    2012-12-11 09:43:52.96 spid17s UPDATE BART_V3_TBL_Orders WITH (ROWLOCK)

    2012-12-11 09:43:52.96 spid17s SET

    2012-12-11 09:43:52.96 spid17s OrderIDP = @orderidp,

    2012-12-11 09:43:52.96 spid17s OrderedByLogin = @orderedbylogin,

    2012-12-11 09:43:52.96 spid17s HardwareSKU = @hardwaresku,

    2012-12-11 09:43:52.96 spid17s InstallSKU = @installsku,

    2012-12-11 09:43:52.96 spid17s DeinstallSKU = @deinstallsku,

    2012-12-11 09:43:52.96 spid17s OrderType = @ordertype,

    2012-12-11 09:43:52.96 spid17s OrderStatus = 'O',

    2012-12-11 09:43:52.96 spid17s OrderDate = @orderdate,

    2012-12-11 09:43:52.96 spid17s ImageSKU = @imagesku,

    2012-12-11 09:43:52.96 spid17s Platform = @imagesku,

    2012-12-11 09:43:52.96 spid17s ImageSKU_Justification = @imagejustification,

    2012-12-11 09:43:52.96 spid17s OrderID = @fullorderid,

    2012-12-11 09:43:52.96 spid17s LOB = @lobname,

    2012-12-11 09:43:52.96 spid17s SubmittedToLogin = @submittedtologin,

    2012-12-11 09:43:52.96 spid17s ShipTo = @shipto,

    2012-12-11 09:43:52.96 spid17s AvailableOrders = '0',

    2012-12-11 09:43:52.96 spid17s AvailableMachines = '0',

    2012-12-11 09:43:52.96 spid17s HP_Installation = @hpinstall,

    2012-12-11 09:43:52.96 spid17s DisposalSKUQuantity = @disposalskuqty,

    2012-12-11 09:43:52.96 spid17s ExpediteDelivery = @expeditedelivery,

    2012-12-11 09:43:52.96 spid17s DeliveryInstructions = @deliveryinstructions,

    2012-12-11 09:43:52.96 spid17s eRequestNbr = @erequestnumber,

    2012-12-11 09:43:52.96 spid17s PAR_TCMS_Nbr = @partcmsnbr,

    2012-12-11 09:43:52.96 spid17s BusinessJustification = @businessjustific

    2012-12-11 09:43:52.96 spid17s inputbuf

    2012-12-11 09:43:52.96 spid17s process id=processb84d48 taskpriority=0 logused=6320 waitresource=PAGE: 6:1:23991 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x14027e10 lockMode=U schedulerid=4 kpid=12056 status=suspended spid=80 sbid=0 ecid=2 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:43:52.96 spid17s executionStack

    2012-12-11 09:43:52.96 spid17s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:43:52.96 spid17s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:43:52.96 spid17s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.96 spid17s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:43:52.96 spid17s frame procname=BART.dbo.BART_SP_PROCESS_ORDER_UPD line=71 stmtstart=5554 stmtend=8368 sqlhandle=0x030006001601c27115125c011da000000100000000000000

    2012-12-11 09:43:52.96 spid17s UPDATE BART_V3_TBL_Orders WITH (ROWLOCK)

    2012-12-11 09:43:52.96 spid17s SET

    2012-12-11 09:43:52.96 spid17s OrderIDP = @orderidp,

    2012-12-11 09:43:52.96 spid17s OrderedByLogin = @orderedbylogin,

    2012-12-11 09:43:52.96 spid17s HardwareSKU = @hardwaresku,

    2012-12-11 09:43:52.96 spid17s InstallSKU = @installsku,

    2012-12-11 09:43:52.96 spid17s DeinstallSKU = @deinstallsku,

    2012-12-11 09:43:52.96 spid17s OrderType = @ordertype,

    2012-12-11 09:43:52.96 spid17s OrderStatus = 'O',

    2012-12-11 09:43:52.96 spid17s OrderDate = @orderdate,

    2012-12-11 09:43:52.96 spid17s ImageSKU = @imagesku,

    2012-12-11 09:43:52.96 spid17s Platform = @imagesku,

    2012-12-11 09:43:52.96 spid17s ImageSKU_Justification = @imagejustification,

    2012-12-11 09:43:52.96 spid17s OrderID = @fullorderid,

    2012-12-11 09:43:52.96 spid17s LOB = @lobname,

    2012-12-11 09:43:52.96 spid17s SubmittedToLogin = @submittedtologin,

    2012-12-11 09:43:52.96 spid17s ShipTo = @shipto,

    2012-12-11 09:43:52.96 spid17s AvailableOrders = '0',

    2012-12-11 09:43:52.96 spid17s AvailableMachines = '0',

    2012-12-11 09:43:52.96 spid17s HP_Installation = @hpinstall,

    2012-12-11 09:43:52.96 spid17s DisposalSKUQuantity = @disposalskuqty,

    2012-12-11 09:43:52.96 spid17s ExpediteDelivery = @expeditedelivery,

    2012-12-11 09:43:52.96 spid17s DeliveryInstructions = @deliveryinstructions,

    2012-12-11 09:43:52.96 spid17s eRequestNbr = @erequestnumber,

    2012-12-11 09:43:52.96 spid17s PAR_TCMS_Nbr = @partcmsnbr,

    2012-12-11 09:43:52.96 spid17s BusinessJustification = @businessjustific

    2012-12-11 09:43:52.96 spid17s inputbuf

    2012-12-11 09:43:52.96 spid17s process id=processc1b3d8 taskpriority=0 logused=6320 waitresource=PAGE: 6:1:39479 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x5f596240 lockMode=U schedulerid=5 kpid=6192 status=suspended spid=80 sbid=0 ecid=7 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:43:52.96 spid17s executionStack

    2012-12-11 09:43:52.96 spid17s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:43:52.96 spid17s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:43:52.96 spid17s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.96 spid17s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:43:52.96 spid17s frame procname=BART.dbo.BART_SP_PROCESS_ORDER_UPD line=71 stmtstart=5554 stmtend=8368 sqlhandle=0x030006001601c27115125c011da000000100000000000000

    2012-12-11 09:43:52.96 spid17s UPDATE BART_V3_TBL_Orders WITH (ROWLOCK)

    2012-12-11 09:43:52.96 spid17s SET

    2012-12-11 09:43:52.96 spid17s OrderIDP = @orderidp,

    2012-12-11 09:43:52.96 spid17s OrderedByLogin = @orderedbylogin,

    2012-12-11 09:43:52.96 spid17s HardwareSKU = @hardwaresku,

    2012-12-11 09:43:52.96 spid17s InstallSKU = @installsku,

    2012-12-11 09:43:52.96 spid17s DeinstallSKU = @deinstallsku,

    2012-12-11 09:43:52.96 spid17s OrderType = @ordertype,

    2012-12-11 09:43:52.96 spid17s OrderStatus = 'O',

    2012-12-11 09:43:52.96 spid17s OrderDate = @orderdate,

    2012-12-11 09:43:52.96 spid17s ImageSKU = @imagesku,

    2012-12-11 09:43:52.96 spid17s Platform = @imagesku,

    2012-12-11 09:43:52.96 spid17s ImageSKU_Justification = @imagejustification,

    2012-12-11 09:43:52.96 spid17s OrderID = @fullorderid,

    2012-12-11 09:43:52.96 spid17s LOB = @lobname,

    2012-12-11 09:43:52.96 spid17s SubmittedToLogin = @submittedtologin,

    2012-12-11 09:43:52.96 spid17s ShipTo = @shipto,

    2012-12-11 09:43:52.96 spid17s AvailableOrders = '0',

    2012-12-11 09:43:52.96 spid17s AvailableMachines = '0',

    2012-12-11 09:43:52.96 spid17s HP_Installation = @hpinstall,

    2012-12-11 09:43:52.96 spid17s DisposalSKUQuantity = @disposalskuqty,

    2012-12-11 09:43:52.96 spid17s ExpediteDelivery = @expeditedelivery,

    2012-12-11 09:43:52.96 spid17s DeliveryInstructions = @deliveryinstructions,

    2012-12-11 09:43:52.96 spid17s eRequestNbr = @erequestnumber,

    2012-12-11 09:43:52.96 spid17s PAR_TCMS_Nbr = @partcmsnbr,

    2012-12-11 09:43:52.96 spid17s BusinessJustification = @businessjustific

    2012-12-11 09:43:52.96 spid17s inputbuf

    2012-12-11 09:43:52.96 spid17s process id=processdb1f18 taskpriority=0 logused=6320 waitresource=PAGE: 6:1:39599 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x1402fbe8 lockMode=U schedulerid=6 kpid=11096 status=suspended spid=80 sbid=0 ecid=5 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:43:52.96 spid17s executionStack

    2012-12-11 09:43:52.96 spid17s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:43:52.96 spid17s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:43:52.96 spid17s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.96 spid17s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:43:52.96 spid17s frame procname=BART.dbo.BART_SP_PROCESS_ORDER_UPD line=71 stmtstart=5554 stmtend=8368 sqlhandle=0x030006001601c27115125c011da000000100000000000000

    2012-12-11 09:43:52.96 spid17s UPDATE BART_V3_TBL_Orders WITH (ROWLOCK)

    2012-12-11 09:43:52.96 spid17s SET

    2012-12-11 09:43:52.96 spid17s OrderIDP = @orderidp,

    2012-12-11 09:43:52.96 spid17s OrderedByLogin = @orderedbylogin,

    2012-12-11 09:43:52.96 spid17s HardwareSKU = @hardwaresku,

    2012-12-11 09:43:52.96 spid17s InstallSKU = @installsku,

    2012-12-11 09:43:52.96 spid17s DeinstallSKU = @deinstallsku,

    2012-12-11 09:43:52.96 spid17s OrderType = @ordertype,

    2012-12-11 09:43:52.96 spid17s OrderStatus = 'O',

    2012-12-11 09:43:52.96 spid17s OrderDate = @orderdate,

    2012-12-11 09:43:52.96 spid17s ImageSKU = @imagesku,

    2012-12-11 09:43:52.96 spid17s Platform = @imagesku,

    2012-12-11 09:43:52.96 spid17s ImageSKU_Justification = @imagejustification,

    2012-12-11 09:43:52.96 spid17s OrderID = @fullorderid,

    2012-12-11 09:43:52.96 spid17s LOB = @lobname,

    2012-12-11 09:43:52.96 spid17s SubmittedToLogin = @submittedtologin,

    2012-12-11 09:43:52.96 spid17s ShipTo = @shipto,

    2012-12-11 09:43:52.96 spid17s AvailableOrders = '0',

    2012-12-11 09:43:52.96 spid17s AvailableMachines = '0',

    2012-12-11 09:43:52.96 spid17s HP_Installation = @hpinstall,

    2012-12-11 09:43:52.96 spid17s DisposalSKUQuantity = @disposalskuqty,

    2012-12-11 09:43:52.96 spid17s ExpediteDelivery = @expeditedelivery,

    2012-12-11 09:43:52.96 spid17s DeliveryInstructions = @deliveryinstructions,

    2012-12-11 09:43:52.96 spid17s eRequestNbr = @erequestnumber,

    2012-12-11 09:43:52.96 spid17s PAR_TCMS_Nbr = @partcmsnbr,

    2012-12-11 09:43:52.96 spid17s BusinessJustification = @businessjustific

    2012-12-11 09:43:52.96 spid17s inputbuf

    2012-12-11 09:43:52.96 spid17s process id=processdc63e8 taskpriority=0 logused=6320 waitresource=PAGE: 6:1:23752 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x20197e08 lockMode=U schedulerid=7 kpid=9300 status=suspended spid=80 sbid=0 ecid=4 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:43:52.96 spid17s executionStack

    2012-12-11 09:43:52.97 spid17s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:43:52.97 spid17s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:43:52.97 spid17s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.97 spid17s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:43:52.97 spid17s frame procname=BART.dbo.BART_SP_PROCESS_ORDER_UPD line=71 stmtstart=5554 stmtend=8368 sqlhandle=0x030006001601c27115125c011da000000100000000000000

    2012-12-11 09:43:52.97 spid17s UPDATE BART_V3_TBL_Orders WITH (ROWLOCK)

    2012-12-11 09:43:52.97 spid17s SET

    2012-12-11 09:43:52.97 spid17s OrderIDP = @orderidp,

    2012-12-11 09:43:52.97 spid17s OrderedByLogin = @orderedbylogin,

    2012-12-11 09:43:52.97 spid17s HardwareSKU = @hardwaresku,

    2012-12-11 09:43:52.97 spid17s InstallSKU = @installsku,

    2012-12-11 09:43:52.97 spid17s DeinstallSKU = @deinstallsku,

    2012-12-11 09:43:52.97 spid17s OrderType = @ordertype,

    2012-12-11 09:43:52.97 spid17s OrderStatus = 'O',

    2012-12-11 09:43:52.97 spid17s OrderDate = @orderdate,

    2012-12-11 09:43:52.97 spid17s ImageSKU = @imagesku,

    2012-12-11 09:43:52.97 spid17s Platform = @imagesku,

    2012-12-11 09:43:52.97 spid17s ImageSKU_Justification = @imagejustification,

    2012-12-11 09:43:52.97 spid17s OrderID = @fullorderid,

    2012-12-11 09:43:52.97 spid17s LOB = @lobname,

    2012-12-11 09:43:52.97 spid17s SubmittedToLogin = @submittedtologin,

    2012-12-11 09:43:52.97 spid17s ShipTo = @shipto,

    2012-12-11 09:43:52.97 spid17s AvailableOrders = '0',

    2012-12-11 09:43:52.97 spid17s AvailableMachines = '0',

    2012-12-11 09:43:52.97 spid17s HP_Installation = @hpinstall,

    2012-12-11 09:43:52.97 spid17s DisposalSKUQuantity = @disposalskuqty,

    2012-12-11 09:43:52.97 spid17s ExpediteDelivery = @expeditedelivery,

    2012-12-11 09:43:52.97 spid17s DeliveryInstructions = @deliveryinstructions,

    2012-12-11 09:43:52.97 spid17s eRequestNbr = @erequestnumber,

    2012-12-11 09:43:52.97 spid17s PAR_TCMS_Nbr = @partcmsnbr,

    2012-12-11 09:43:52.97 spid17s BusinessJustification = @businessjustific

    2012-12-11 09:43:52.97 spid17s inputbuf

    2012-12-11 09:43:52.97 spid17s process id=processdc76a8 taskpriority=0 logused=20004 waittime=5609 schedulerid=7 kpid=10548 status=suspended spid=80 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 loginname=BART_User isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:43:52.97 spid17s executionStack

    2012-12-11 09:43:52.97 spid17s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:43:52.97 spid17s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:43:52.97 spid17s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.97 spid17s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:43:52.97 spid17s frame procname=BART.dbo.BART_SP_PROCESS_ORDER_UPD line=71 stmtstart=5554 stmtend=8368 sqlhandle=0x030006001601c27115125c011da000000100000000000000

    2012-12-11 09:43:52.97 spid17s UPDATE BART_V3_TBL_Orders WITH (ROWLOCK)

    2012-12-11 09:43:52.97 spid17s SET

    2012-12-11 09:43:52.97 spid17s OrderIDP = @orderidp,

    2012-12-11 09:43:52.97 spid17s OrderedByLogin = @orderedbylogin,

    2012-12-11 09:43:52.97 spid17s HardwareSKU = @hardwaresku,

    2012-12-11 09:43:52.97 spid17s InstallSKU = @installsku,

    2012-12-11 09:43:52.97 spid17s DeinstallSKU = @deinstallsku,

    2012-12-11 09:43:52.97 spid17s OrderType = @ordertype,

    2012-12-11 09:43:52.97 spid17s OrderStatus = 'O',

    2012-12-11 09:43:52.97 spid17s OrderDate = @orderdate,

    2012-12-11 09:43:52.97 spid17s ImageSKU = @imagesku,

    2012-12-11 09:43:52.97 spid17s Platform = @imagesku,

    2012-12-11 09:43:52.97 spid17s ImageSKU_Justification = @imagejustification,

    2012-12-11 09:43:52.97 spid17s OrderID = @fullorderid,

    2012-12-11 09:43:52.97 spid17s LOB = @lobname,

    2012-12-11 09:43:52.97 spid17s SubmittedToLogin = @submittedtologin,

    2012-12-11 09:43:52.97 spid17s ShipTo = @shipto,

    2012-12-11 09:43:52.97 spid17s AvailableOrders = '0',

    2012-12-11 09:43:52.97 spid17s AvailableMachines = '0',

    2012-12-11 09:43:52.97 spid17s HP_Installation = @hpinstall,

    2012-12-11 09:43:52.97 spid17s DisposalSKUQuantity = @disposalskuqty,

    2012-12-11 09:43:52.97 spid17s ExpediteDelivery = @expeditedelivery,

    2012-12-11 09:43:52.97 spid17s DeliveryInstructions = @deliveryinstructions,

    2012-12-11 09:43:52.97 spid17s eRequestNbr = @erequestnumber,

    2012-12-11 09:43:52.97 spid17s PAR_TCMS_Nbr = @partcmsnbr,

    2012-12-11 09:43:52.97 spid17s BusinessJustification = @businessjustific

    2012-12-11 09:43:52.97 spid17s inputbuf

    2012-12-11 09:43:52.97 spid17s Proc [Database Id = 6 Object Id = 1908539670]

    2012-12-11 09:43:52.97 spid17s process id=processedcd48 taskpriority=0 logused=6320 waitresource=PAGE: 6:3:77 waittime=5609 ownerId=2095798753 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:47.277 XDES=0x140378c0 lockMode=U schedulerid=8 kpid=8020 status=suspended spid=80 sbid=0 ecid=3 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:47.277 lastbatchcompleted=2012-12-11T09:43:47.277 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095798753 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:43:52.97 spid17s executionStack

    2012-12-11 09:43:52.97 spid17s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:43:52.97 spid17s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:43:52.97 spid17s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:43:52.97 spid17s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:43:52.97 spid17s frame procname=BART.dbo.BART_SP_PROCESS_ORDER_UPD line=71 stmtstart=5554 stmtend=8368 sqlhandle=0x030006001601c27115125c011da000000100000000000000

    2012-12-11 09:43:52.97 spid17s UPDATE BART_V3_TBL_Orders WITH (ROWLOCK)

    2012-12-11 09:43:52.97 spid17s SET

    2012-12-11 09:43:52.97 spid17s OrderIDP = @orderidp,

    2012-12-11 09:43:52.97 spid17s OrderedByLogin = @orderedbylogin,

    2012-12-11 09:43:52.97 spid17s HardwareSKU = @hardwaresku,

    2012-12-11 09:43:52.97 spid17s InstallSKU = @installsku,

    2012-12-11 09:43:52.97 spid17s DeinstallSKU = @deinstallsku,

    2012-12-11 09:43:52.97 spid17s OrderType = @ordertype,

    2012-12-11 09:43:52.97 spid17s OrderStatus = 'O',

    2012-12-11 09:43:52.97 spid17s OrderDate = @orderdate,

    2012-12-11 09:43:52.97 spid17s ImageSKU = @imagesku,

    2012-12-11 09:43:52.97 spid17s Platform = @imagesku,

    2012-12-11 09:43:52.97 spid17s ImageSKU_Justification = @imagejustification,

    2012-12-11 09:43:52.97 spid17s OrderID = @fullorderid,

    2012-12-11 09:43:52.97 spid17s LOB = @lobname,

    2012-12-11 09:43:52.97 spid17s SubmittedToLogin = @submittedtologin,

    2012-12-11 09:43:52.97 spid17s ShipTo = @shipto,

    2012-12-11 09:43:52.97 spid17s AvailableOrders = '0',

    2012-12-11 09:43:52.97 spid17s AvailableMachines = '0',

    2012-12-11 09:43:52.97 spid17s HP_Installation = @hpinstall,

    2012-12-11 09:43:52.97 spid17s DisposalSKUQuantity = @disposalskuqty,

    2012-12-11 09:43:52.97 spid17s ExpediteDelivery = @expeditedelivery,

    2012-12-11 09:43:52.97 spid17s DeliveryInstructions = @deliveryinstructions,

    2012-12-11 09:43:52.97 spid17s eRequestNbr = @erequestnumber,

    2012-12-11 09:43:52.97 spid17s PAR_TCMS_Nbr = @partcmsnbr,

    2012-12-11 09:43:52.97 spid17s BusinessJustification = @businessjustific

    2012-12-11 09:43:52.97 spid17s inputbuf

    2012-12-11 09:43:52.97 spid17s resource-list

    2012-12-11 09:43:52.97 spid17s pagelock fileid=3 pageid=77 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock1c4ddf80 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:43:52.97 spid17s owner-list

    2012-12-11 09:43:52.97 spid17s owner id=process8d9978 mode=U

    2012-12-11 09:43:52.97 spid17s owner id=process8d9978 mode=U

    2012-12-11 09:43:52.97 spid17s waiter-list

    2012-12-11 09:43:52.97 spid17s waiter id=processedcd48 mode=U requestType=wait

    2012-12-11 09:43:52.97 spid17s exchangeEvent id=port1413cf00 nodeId=4

    2012-12-11 09:43:52.97 spid17s owner-list

    2012-12-11 09:43:52.97 spid17s owner event=e_waitNone type=producer id=process8de3e8

    2012-12-11 09:43:52.97 spid17s owner event=e_waitNone type=producer id=processedcd48

    2012-12-11 09:43:52.97 spid17s owner event=e_waitNone type=producer id=processdc63e8

    2012-12-11 09:43:52.97 spid17s owner event=e_waitNone type=producer id=processb84d48

    2012-12-11 09:43:52.97 spid17s owner event=e_waitNone type=producer id=processdb1f18

    2012-12-11 09:43:52.97 spid17s owner event=e_waitNone type=producer id=process84b108

    2012-12-11 09:43:52.97 spid17s owner event=e_waitNone type=producer id=processc1b3d8

    2012-12-11 09:43:52.97 spid17s owner event=e_waitNone type=producer id=process8d9c48

    2012-12-11 09:43:52.97 spid17s waiter-list

    2012-12-11 09:43:52.97 spid17s waiter event=e_waitPipeGetRow type=consumer id=processdc76a8

    2012-12-11 09:43:52.97 spid17s pagelock fileid=3 pageid=1158397 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock2d6f9880 mode=IX associatedObjectId=72057603290365952

    2012-12-11 09:43:52.97 spid17s owner-list

    2012-12-11 09:43:52.97 spid17s owner id=processdc76a8 mode=IX

    2012-12-11 09:43:52.97 spid17s waiter-list

    2012-12-11 09:43:52.97 spid17s waiter id=process84ab68 mode=U requestType=wait

    2012-12-11 09:43:52.97 spid17s pagelock fileid=1 pageid=34110 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock60682d80 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:43:52.97 spid17s owner-list

    2012-12-11 09:43:52.97 spid17s owner id=process84ab68 mode=U

    2012-12-11 09:43:52.97 spid17s waiter-list

    2012-12-11 09:43:52.97 spid17s waiter id=process84b108 mode=U requestType=wait

    2012-12-11 09:43:52.97 spid17s pagelock fileid=1 pageid=23752 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock4ceef880 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:43:52.97 spid17s owner-list

    2012-12-11 09:43:52.97 spid17s owner id=process8d9978 mode=U

    2012-12-11 09:43:52.97 spid17s waiter-list

    2012-12-11 09:43:52.97 spid17s waiter id=processdc63e8 mode=U requestType=wait

    2012-12-11 09:43:52.97 spid17s pagelock fileid=1 pageid=39599 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock530a5ac0 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:43:52.97 spid17s owner-list

    2012-12-11 09:43:52.97 spid17s owner id=process8d9978 mode=U

    2012-12-11 09:43:52.97 spid17s owner id=process8d9978 mode=U

    2012-12-11 09:43:52.97 spid17s waiter-list

    2012-12-11 09:43:52.97 spid17s waiter id=processdb1f18 mode=U requestType=wait

    2012-12-11 09:43:52.97 spid17s pagelock fileid=1 pageid=39479 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock557e8c80 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:43:52.97 spid17s owner-list

    2012-12-11 09:43:52.97 spid17s owner id=process8d9978 mode=U

    2012-12-11 09:43:52.97 spid17s owner id=process8d9978 mode=U

    2012-12-11 09:43:52.97 spid17s waiter-list

    2012-12-11 09:43:52.97 spid17s waiter id=processc1b3d8 mode=U requestType=wait

    2012-12-11 09:43:52.97 spid17s pagelock fileid=1 pageid=42765 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock58220c00 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:43:52.97 spid17s owner-list

    2012-12-11 09:43:52.97 spid17s owner id=process84ab68 mode=U

    2012-12-11 09:43:52.97 spid17s waiter-list

    2012-12-11 09:43:52.97 spid17s waiter id=process8d9c48 mode=U requestType=wait

    2012-12-11 09:43:52.97 spid17s pagelock fileid=1 pageid=23991 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock5b2e6e80 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:43:52.97 spid17s owner-list

    2012-12-11 09:43:52.97 spid17s owner id=process8d9978 mode=U

    2012-12-11 09:43:52.97 spid17s waiter-list

    2012-12-11 09:43:52.97 spid17s waiter id=processb84d48 mode=U requestType=wait

    2012-12-11 09:43:52.97 spid17s pagelock fileid=3 pageid=715812 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock617a0cc0 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:43:52.97 spid17s owner-list

    2012-12-11 09:43:52.97 spid17s owner id=process8d9978 mode=U

    2012-12-11 09:43:52.97 spid17s waiter-list

    2012-12-11 09:43:52.97 spid17s waiter id=process8de3e8 mode=U requestType=wait

    2012-12-11 09:43:52.97 spid17s exchangeEvent id=port1413d300 nodeId=4

    2012-12-11 09:43:52.97 spid17s owner-list

    2012-12-11 09:43:52.97 spid17s owner event=e_waitNone type=producer id=process84ab68

    2012-12-11 09:43:52.97 spid17s waiter-list

    2012-12-11 09:43:52.97 spid17s waiter event=e_waitPipeGetRow type=consumer id=process8d9978

    The Variant I mentioned:

    2012-12-11 09:44:00.50 spid18s deadlock-list

    2012-12-11 09:44:00.50 spid18s deadlock victim=processdc7a68

    2012-12-11 09:44:00.50 spid18s process-list

    2012-12-11 09:44:00.50 spid18s process id=process84a988 taskpriority=0 logused=7920 waitresource=PAGE: 6:3:715812 waittime=2656 ownerId=2095810397 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:57.573 XDES=0x159142d0 lockMode=U schedulerid=1 kpid=9028 status=suspended spid=52 sbid=0 ecid=4 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:57.520 lastbatchcompleted=2012-12-11T09:43:57.520 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=3732 isolationlevel=read uncommitted (1) xactid=2095810397 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:44:00.50 spid18s executionStack

    2012-12-11 09:44:00.50 spid18s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:44:00.50 spid18s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:44:00.50 spid18s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.50 spid18s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:44:00.50 spid18s frame procname=BART.dbo.Upd_Po_Update_Date line=6 stmtstart=220 stmtend=536 sqlhandle=0x03000600e42911567bcd7000df9d00000000000000000000

    2012-12-11 09:44:00.50 spid18s UPDATE BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.50 spid18s SET PoUpdateDate = getdate()

    2012-12-11 09:44:00.50 spid18s FROM inserted, BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.50 spid18s WHERE BART_V3_TBL_ORDERS.WorkstationOID = Inserted.WorkstationOID

    2012-12-11 09:44:00.50 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_ACTION_UPD line=361 stmtstart=23054 stmtend=26068 sqlhandle=0x03000600c45d59684202610194a000000100000000000000

    2012-12-11 09:44:00.50 spid18s UPDATE BART_V3_TBL_Orders

    2012-12-11 09:44:00.50 spid18s SET

    2012-12-11 09:44:00.50 spid18s OrderedByLogin = @FROM_OrderedByLogin,

    2012-12-11 09:44:00.50 spid18s HardwareSKU = @FROM_HardwareSKU,

    2012-12-11 09:44:00.50 spid18s InstallSKU = @FROM_InstallSKU,

    2012-12-11 09:44:00.50 spid18s DeinstallSKU = @FROM_DeinstallSKU,

    2012-12-11 09:44:00.50 spid18s OrderType = @FROM_OrderType,

    2012-12-11 09:44:00.50 spid18s Platform = @FROM_Platform,

    2012-12-11 09:44:00.50 spid18s OrderStatus = @FROM_OrderStatus,

    2012-12-11 09:44:00.50 spid18s OrderDate = @FROM_OrderDate,

    2012-12-11 09:44:00.50 spid18s ImageSKU = @FROM_ImageSKU,

    2012-12-11 09:44:00.50 spid18s OrderID = @FROM_OrderID,

    2012-12-11 09:44:00.50 spid18s OrderIDP = @FROM_OrderIDP,

    2012-12-11 09:44:00.50 spid18s LOB = @FROM_LOB,

    2012-12-11 09:44:00.50 spid18s SubmittedByLogin = @FROM_SubmittedByLogin,

    2012-12-11 09:44:00.50 spid18s SubmittedDate = @FROM_SubmittedDate,

    2012-12-11 09:44:00.50 spid18s SubmittedToCOGDate = @FROM_SubmittedToCOGDate,

    2012-12-11 09:44:00.50 spid18s AvailableOrders = @FROM_AvailableOrders,

    2012-12-11 09:44:00.50 spid18s AvailableMachines = @FROM_AvailableMachines,

    2012-12-11 09:44:00.50 spid18s POnumber = @FROM_POnumber,

    2012-12-11 09:44:00.50 spid18s POdate = @FROM_POdate,

    2012-12-11 09:44:00.50 spid18s COGclerk = @FROM_COGclerk,

    2012-12-11 09:44:00.50 spid18s SVCnumber = @FROM_SVCnumber,

    2012-12-11 09:44:00.50 spid18s DELLnumber = @FROM_DELLnumber,

    2012-12-11 09:44:00.50 spid18s PoUpdateSource = @FROM_PoUpdateSource,

    2012-12-11 09:44:00.50 spid18s PoUpdateDate = @FROM_PoUpdateDate,

    2012-12-11 09:44:00.50 spid18s COGclerkAssigned = @FROM_COGclerkAssigned,

    2012-12-11 09:44:00.50 spid18s TrackingInfo = @FROM_TrackingInfo,

    2012-12-11 09:44:00.50 spid18s DeliveryInstructions = @FROM_DeliveryInstructions,

    2012-12-11 09:44:00.50 spid18s BusinessJustification = @FROM_Bu

    2012-12-11 09:44:00.50 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_QUEUE_UPD line=32 stmtstart=1694 stmtend=1866 sqlhandle=0x0300060058c22d35ec526600679d00000100000000000000

    2012-12-11 09:44:00.50 spid18s EXEC BART_SP_REFRESH_PRMOVE_ACTION_UPD @FROM_TRACKINGNUMBER, @TO_TRACKINGNUMBER

    2012-12-11 09:44:00.50 spid18s inputbuf

    2012-12-11 09:44:00.50 spid18s process id=process8d9978 taskpriority=0 logused=20004 waittime=2656 schedulerid=2 kpid=9056 status=suspended spid=52 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2012-12-11T09:43:57.520 lastbatchcompleted=2012-12-11T09:43:57.520 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=3732 loginname=BART_User isolationlevel=read uncommitted (1) xactid=2095810397 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:44:00.50 spid18s executionStack

    2012-12-11 09:44:00.50 spid18s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:44:00.50 spid18s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:44:00.50 spid18s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.50 spid18s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:44:00.50 spid18s frame procname=BART.dbo.Upd_Po_Update_Date line=6 stmtstart=220 stmtend=536 sqlhandle=0x03000600e42911567bcd7000df9d00000000000000000000

    2012-12-11 09:44:00.50 spid18s UPDATE BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.50 spid18s SET PoUpdateDate = getdate()

    2012-12-11 09:44:00.50 spid18s FROM inserted, BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.50 spid18s WHERE BART_V3_TBL_ORDERS.WorkstationOID = Inserted.WorkstationOID

    2012-12-11 09:44:00.50 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_ACTION_UPD line=361 stmtstart=23054 stmtend=26068 sqlhandle=0x03000600c45d59684202610194a000000100000000000000

    2012-12-11 09:44:00.50 spid18s UPDATE BART_V3_TBL_Orders

    2012-12-11 09:44:00.50 spid18s SET

    2012-12-11 09:44:00.50 spid18s OrderedByLogin = @FROM_OrderedByLogin,

    2012-12-11 09:44:00.50 spid18s HardwareSKU = @FROM_HardwareSKU,

    2012-12-11 09:44:00.50 spid18s InstallSKU = @FROM_InstallSKU,

    2012-12-11 09:44:00.50 spid18s DeinstallSKU = @FROM_DeinstallSKU,

    2012-12-11 09:44:00.50 spid18s OrderType = @FROM_OrderType,

    2012-12-11 09:44:00.50 spid18s Platform = @FROM_Platform,

    2012-12-11 09:44:00.50 spid18s OrderStatus = @FROM_OrderStatus,

    2012-12-11 09:44:00.50 spid18s OrderDate = @FROM_OrderDate,

    2012-12-11 09:44:00.50 spid18s ImageSKU = @FROM_ImageSKU,

    2012-12-11 09:44:00.50 spid18s OrderID = @FROM_OrderID,

    2012-12-11 09:44:00.50 spid18s OrderIDP = @FROM_OrderIDP,

    2012-12-11 09:44:00.50 spid18s LOB = @FROM_LOB,

    2012-12-11 09:44:00.50 spid18s SubmittedByLogin = @FROM_SubmittedByLogin,

    2012-12-11 09:44:00.50 spid18s SubmittedDate = @FROM_SubmittedDate,

    2012-12-11 09:44:00.50 spid18s SubmittedToCOGDate = @FROM_SubmittedToCOGDate,

    2012-12-11 09:44:00.50 spid18s AvailableOrders = @FROM_AvailableOrders,

    2012-12-11 09:44:00.50 spid18s AvailableMachines = @FROM_AvailableMachines,

    2012-12-11 09:44:00.50 spid18s POnumber = @FROM_POnumber,

    2012-12-11 09:44:00.50 spid18s POdate = @FROM_POdate,

    2012-12-11 09:44:00.50 spid18s COGclerk = @FROM_COGclerk,

    2012-12-11 09:44:00.50 spid18s SVCnumber = @FROM_SVCnumber,

    2012-12-11 09:44:00.51 spid18s DELLnumber = @FROM_DELLnumber,

    2012-12-11 09:44:00.51 spid18s PoUpdateSource = @FROM_PoUpdateSource,

    2012-12-11 09:44:00.51 spid18s PoUpdateDate = @FROM_PoUpdateDate,

    2012-12-11 09:44:00.51 spid18s COGclerkAssigned = @FROM_COGclerkAssigned,

    2012-12-11 09:44:00.51 spid18s TrackingInfo = @FROM_TrackingInfo,

    2012-12-11 09:44:00.51 spid18s DeliveryInstructions = @FROM_DeliveryInstructions,

    2012-12-11 09:44:00.51 spid18s BusinessJustification = @FROM_Bu

    2012-12-11 09:44:00.51 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_QUEUE_UPD line=32 stmtstart=1694 stmtend=1866 sqlhandle=0x0300060058c22d35ec526600679d00000100000000000000

    2012-12-11 09:44:00.51 spid18s EXEC BART_SP_REFRESH_PRMOVE_ACTION_UPD @FROM_TRACKINGNUMBER, @TO_TRACKINGNUMBER

    2012-12-11 09:44:00.51 spid18s inputbuf

    2012-12-11 09:44:00.51 spid18s Proc [Database Id = 6 Object Id = 892191320]

    2012-12-11 09:44:00.51 spid18s process id=process8d9a68 taskpriority=0 logused=7920 waitresource=PAGE: 6:1:23752 waittime=2656 ownerId=2095810397 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:57.573 XDES=0x1ae2c9f0 lockMode=U schedulerid=2 kpid=10432 status=suspended spid=52 sbid=0 ecid=7 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:57.520 lastbatchcompleted=2012-12-11T09:43:57.520 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=3732 isolationlevel=read uncommitted (1) xactid=2095810397 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:44:00.51 spid18s executionStack

    2012-12-11 09:44:00.51 spid18s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:44:00.51 spid18s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:44:00.51 spid18s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.51 spid18s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:44:00.51 spid18s frame procname=BART.dbo.Upd_Po_Update_Date line=6 stmtstart=220 stmtend=536 sqlhandle=0x03000600e42911567bcd7000df9d00000000000000000000

    2012-12-11 09:44:00.51 spid18s UPDATE BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.51 spid18s SET PoUpdateDate = getdate()

    2012-12-11 09:44:00.51 spid18s FROM inserted, BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.51 spid18s WHERE BART_V3_TBL_ORDERS.WorkstationOID = Inserted.WorkstationOID

    2012-12-11 09:44:00.51 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_ACTION_UPD line=361 stmtstart=23054 stmtend=26068 sqlhandle=0x03000600c45d59684202610194a000000100000000000000

    2012-12-11 09:44:00.51 spid18s UPDATE BART_V3_TBL_Orders

    2012-12-11 09:44:00.51 spid18s SET

    2012-12-11 09:44:00.51 spid18s OrderedByLogin = @FROM_OrderedByLogin,

    2012-12-11 09:44:00.51 spid18s HardwareSKU = @FROM_HardwareSKU,

    2012-12-11 09:44:00.51 spid18s InstallSKU = @FROM_InstallSKU,

    2012-12-11 09:44:00.51 spid18s DeinstallSKU = @FROM_DeinstallSKU,

    2012-12-11 09:44:00.51 spid18s OrderType = @FROM_OrderType,

    2012-12-11 09:44:00.51 spid18s Platform = @FROM_Platform,

    2012-12-11 09:44:00.51 spid18s OrderStatus = @FROM_OrderStatus,

    2012-12-11 09:44:00.51 spid18s OrderDate = @FROM_OrderDate,

    2012-12-11 09:44:00.51 spid18s ImageSKU = @FROM_ImageSKU,

    2012-12-11 09:44:00.51 spid18s OrderID = @FROM_OrderID,

    2012-12-11 09:44:00.51 spid18s OrderIDP = @FROM_OrderIDP,

    2012-12-11 09:44:00.51 spid18s LOB = @FROM_LOB,

    2012-12-11 09:44:00.51 spid18s SubmittedByLogin = @FROM_SubmittedByLogin,

    2012-12-11 09:44:00.51 spid18s SubmittedDate = @FROM_SubmittedDate,

    2012-12-11 09:44:00.51 spid18s SubmittedToCOGDate = @FROM_SubmittedToCOGDate,

    2012-12-11 09:44:00.51 spid18s AvailableOrders = @FROM_AvailableOrders,

    2012-12-11 09:44:00.51 spid18s AvailableMachines = @FROM_AvailableMachines,

    2012-12-11 09:44:00.51 spid18s POnumber = @FROM_POnumber,

    2012-12-11 09:44:00.51 spid18s POdate = @FROM_POdate,

    2012-12-11 09:44:00.51 spid18s COGclerk = @FROM_COGclerk,

    2012-12-11 09:44:00.51 spid18s SVCnumber = @FROM_SVCnumber,

    2012-12-11 09:44:00.51 spid18s DELLnumber = @FROM_DELLnumber,

    2012-12-11 09:44:00.51 spid18s PoUpdateSource = @FROM_PoUpdateSource,

    2012-12-11 09:44:00.51 spid18s PoUpdateDate = @FROM_PoUpdateDate,

    2012-12-11 09:44:00.51 spid18s COGclerkAssigned = @FROM_COGclerkAssigned,

    2012-12-11 09:44:00.51 spid18s TrackingInfo = @FROM_TrackingInfo,

    2012-12-11 09:44:00.51 spid18s DeliveryInstructions = @FROM_DeliveryInstructions,

    2012-12-11 09:44:00.51 spid18s BusinessJustification = @FROM_Bu

    2012-12-11 09:44:00.51 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_QUEUE_UPD line=32 stmtstart=1694 stmtend=1866 sqlhandle=0x0300060058c22d35ec526600679d00000100000000000000

    2012-12-11 09:44:00.51 spid18s EXEC BART_SP_REFRESH_PRMOVE_ACTION_UPD @FROM_TRACKINGNUMBER, @TO_TRACKINGNUMBER

    2012-12-11 09:44:00.51 spid18s inputbuf

    2012-12-11 09:44:00.51 spid18s process id=process8df108 taskpriority=0 logused=7920 waitresource=PAGE: 6:1:23991 waittime=2656 ownerId=2095810397 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:57.573 XDES=0x58144970 lockMode=U schedulerid=3 kpid=6404 status=suspended spid=52 sbid=0 ecid=1 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:57.520 lastbatchcompleted=2012-12-11T09:43:57.520 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=3732 isolationlevel=read uncommitted (1) xactid=2095810397 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:44:00.51 spid18s executionStack

    2012-12-11 09:44:00.51 spid18s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:44:00.51 spid18s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:44:00.51 spid18s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.51 spid18s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:44:00.51 spid18s frame procname=BART.dbo.Upd_Po_Update_Date line=6 stmtstart=220 stmtend=536 sqlhandle=0x03000600e42911567bcd7000df9d00000000000000000000

    2012-12-11 09:44:00.51 spid18s UPDATE BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.51 spid18s SET PoUpdateDate = getdate()

    2012-12-11 09:44:00.51 spid18s FROM inserted, BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.51 spid18s WHERE BART_V3_TBL_ORDERS.WorkstationOID = Inserted.WorkstationOID

    2012-12-11 09:44:00.51 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_ACTION_UPD line=361 stmtstart=23054 stmtend=26068 sqlhandle=0x03000600c45d59684202610194a000000100000000000000

    2012-12-11 09:44:00.51 spid18s UPDATE BART_V3_TBL_Orders

    2012-12-11 09:44:00.51 spid18s SET

    2012-12-11 09:44:00.51 spid18s OrderedByLogin = @FROM_OrderedByLogin,

    2012-12-11 09:44:00.51 spid18s HardwareSKU = @FROM_HardwareSKU,

    2012-12-11 09:44:00.51 spid18s InstallSKU = @FROM_InstallSKU,

    2012-12-11 09:44:00.51 spid18s DeinstallSKU = @FROM_DeinstallSKU,

    2012-12-11 09:44:00.51 spid18s OrderType = @FROM_OrderType,

    2012-12-11 09:44:00.51 spid18s Platform = @FROM_Platform,

    2012-12-11 09:44:00.51 spid18s OrderStatus = @FROM_OrderStatus,

    2012-12-11 09:44:00.51 spid18s OrderDate = @FROM_OrderDate,

    2012-12-11 09:44:00.51 spid18s ImageSKU = @FROM_ImageSKU,

    2012-12-11 09:44:00.51 spid18s OrderID = @FROM_OrderID,

    2012-12-11 09:44:00.51 spid18s OrderIDP = @FROM_OrderIDP,

    2012-12-11 09:44:00.51 spid18s LOB = @FROM_LOB,

    2012-12-11 09:44:00.51 spid18s SubmittedByLogin = @FROM_SubmittedByLogin,

    2012-12-11 09:44:00.51 spid18s SubmittedDate = @FROM_SubmittedDate,

    2012-12-11 09:44:00.51 spid18s SubmittedToCOGDate = @FROM_SubmittedToCOGDate,

    2012-12-11 09:44:00.51 spid18s AvailableOrders = @FROM_AvailableOrders,

    2012-12-11 09:44:00.51 spid18s AvailableMachines = @FROM_AvailableMachines,

    2012-12-11 09:44:00.51 spid18s POnumber = @FROM_POnumber,

    2012-12-11 09:44:00.51 spid18s POdate = @FROM_POdate,

    2012-12-11 09:44:00.51 spid18s COGclerk = @FROM_COGclerk,

    2012-12-11 09:44:00.51 spid18s SVCnumber = @FROM_SVCnumber,

    2012-12-11 09:44:00.51 spid18s DELLnumber = @FROM_DELLnumber,

    2012-12-11 09:44:00.51 spid18s PoUpdateSource = @FROM_PoUpdateSource,

    2012-12-11 09:44:00.51 spid18s PoUpdateDate = @FROM_PoUpdateDate,

    2012-12-11 09:44:00.51 spid18s COGclerkAssigned = @FROM_COGclerkAssigned,

    2012-12-11 09:44:00.51 spid18s TrackingInfo = @FROM_TrackingInfo,

    2012-12-11 09:44:00.51 spid18s DeliveryInstructions = @FROM_DeliveryInstructions,

    2012-12-11 09:44:00.51 spid18s BusinessJustification = @FROM_Bu

    2012-12-11 09:44:00.51 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_QUEUE_UPD line=32 stmtstart=1694 stmtend=1866 sqlhandle=0x0300060058c22d35ec526600679d00000100000000000000

    2012-12-11 09:44:00.51 spid18s EXEC BART_SP_REFRESH_PRMOVE_ACTION_UPD @FROM_TRACKINGNUMBER, @TO_TRACKINGNUMBER

    2012-12-11 09:44:00.51 spid18s inputbuf

    2012-12-11 09:44:00.51 spid18s process id=processb854c8 taskpriority=0 logused=7920 waitresource=PAGE: 6:1:39479 waittime=2656 ownerId=2095810397 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:57.573 XDES=0x14027e10 lockMode=U schedulerid=4 kpid=8060 status=suspended spid=52 sbid=0 ecid=5 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:57.520 lastbatchcompleted=2012-12-11T09:43:57.520 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=3732 isolationlevel=read uncommitted (1) xactid=2095810397 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:44:00.51 spid18s executionStack

    2012-12-11 09:44:00.51 spid18s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:44:00.51 spid18s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:44:00.51 spid18s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.51 spid18s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:44:00.51 spid18s frame procname=BART.dbo.Upd_Po_Update_Date line=6 stmtstart=220 stmtend=536 sqlhandle=0x03000600e42911567bcd7000df9d00000000000000000000

    2012-12-11 09:44:00.51 spid18s UPDATE BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.51 spid18s SET PoUpdateDate = getdate()

    2012-12-11 09:44:00.51 spid18s FROM inserted, BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.51 spid18s WHERE BART_V3_TBL_ORDERS.WorkstationOID = Inserted.WorkstationOID

    2012-12-11 09:44:00.51 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_ACTION_UPD line=361 stmtstart=23054 stmtend=26068 sqlhandle=0x03000600c45d59684202610194a000000100000000000000

    2012-12-11 09:44:00.51 spid18s UPDATE BART_V3_TBL_Orders

    2012-12-11 09:44:00.51 spid18s SET

    2012-12-11 09:44:00.51 spid18s OrderedByLogin = @FROM_OrderedByLogin,

    2012-12-11 09:44:00.51 spid18s HardwareSKU = @FROM_HardwareSKU,

    2012-12-11 09:44:00.51 spid18s InstallSKU = @FROM_InstallSKU,

    2012-12-11 09:44:00.51 spid18s DeinstallSKU = @FROM_DeinstallSKU,

    2012-12-11 09:44:00.51 spid18s OrderType = @FROM_OrderType,

    2012-12-11 09:44:00.51 spid18s Platform = @FROM_Platform,

    2012-12-11 09:44:00.51 spid18s OrderStatus = @FROM_OrderStatus,

    2012-12-11 09:44:00.51 spid18s OrderDate = @FROM_OrderDate,

    2012-12-11 09:44:00.51 spid18s ImageSKU = @FROM_ImageSKU,

    2012-12-11 09:44:00.51 spid18s OrderID = @FROM_OrderID,

    2012-12-11 09:44:00.51 spid18s OrderIDP = @FROM_OrderIDP,

    2012-12-11 09:44:00.51 spid18s LOB = @FROM_LOB,

    2012-12-11 09:44:00.51 spid18s SubmittedByLogin = @FROM_SubmittedByLogin,

    2012-12-11 09:44:00.51 spid18s SubmittedDate = @FROM_SubmittedDate,

    2012-12-11 09:44:00.51 spid18s SubmittedToCOGDate = @FROM_SubmittedToCOGDate,

    2012-12-11 09:44:00.51 spid18s AvailableOrders = @FROM_AvailableOrders,

    2012-12-11 09:44:00.51 spid18s AvailableMachines = @FROM_AvailableMachines,

    2012-12-11 09:44:00.51 spid18s POnumber = @FROM_POnumber,

    2012-12-11 09:44:00.51 spid18s POdate = @FROM_POdate,

    2012-12-11 09:44:00.51 spid18s COGclerk = @FROM_COGclerk,

    2012-12-11 09:44:00.51 spid18s SVCnumber = @FROM_SVCnumber,

    2012-12-11 09:44:00.51 spid18s DELLnumber = @FROM_DELLnumber,

    2012-12-11 09:44:00.51 spid18s PoUpdateSource = @FROM_PoUpdateSource,

    2012-12-11 09:44:00.51 spid18s PoUpdateDate = @FROM_PoUpdateDate,

    2012-12-11 09:44:00.51 spid18s COGclerkAssigned = @FROM_COGclerkAssigned,

    2012-12-11 09:44:00.51 spid18s TrackingInfo = @FROM_TrackingInfo,

    2012-12-11 09:44:00.51 spid18s DeliveryInstructions = @FROM_DeliveryInstructions,

    2012-12-11 09:44:00.51 spid18s BusinessJustification = @FROM_Bu

    2012-12-11 09:44:00.51 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_QUEUE_UPD line=32 stmtstart=1694 stmtend=1866 sqlhandle=0x0300060058c22d35ec526600679d00000100000000000000

    2012-12-11 09:44:00.51 spid18s EXEC BART_SP_REFRESH_PRMOVE_ACTION_UPD @FROM_TRACKINGNUMBER, @TO_TRACKINGNUMBER

    2012-12-11 09:44:00.51 spid18s inputbuf

    2012-12-11 09:44:00.52 spid18s process id=processc1ab68 taskpriority=0 logused=20004 waittime=1609 schedulerid=5 kpid=10988 status=suspended spid=70 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2012-12-11T09:43:56.043 lastbatchcompleted=2012-12-11T09:43:56.043 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 loginname=BART_User isolationlevel=read uncommitted (1) xactid=2095809566 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:44:00.52 spid18s executionStack

    2012-12-11 09:44:00.52 spid18s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:44:00.52 spid18s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:44:00.52 spid18s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.52 spid18s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:44:00.52 spid18s frame procname=BART.dbo.BART_SP_PROCESS_ORDER_UPD line=71 stmtstart=5554 stmtend=8368 sqlhandle=0x030006001601c27115125c011da000000100000000000000

    2012-12-11 09:44:00.52 spid18s UPDATE BART_V3_TBL_Orders WITH (ROWLOCK)

    2012-12-11 09:44:00.52 spid18s SET

    2012-12-11 09:44:00.52 spid18s OrderIDP = @orderidp,

    2012-12-11 09:44:00.52 spid18s OrderedByLogin = @orderedbylogin,

    2012-12-11 09:44:00.52 spid18s HardwareSKU = @hardwaresku,

    2012-12-11 09:44:00.52 spid18s InstallSKU = @installsku,

    2012-12-11 09:44:00.52 spid18s DeinstallSKU = @deinstallsku,

    2012-12-11 09:44:00.52 spid18s OrderType = @ordertype,

    2012-12-11 09:44:00.52 spid18s OrderStatus = 'O',

    2012-12-11 09:44:00.52 spid18s OrderDate = @orderdate,

    2012-12-11 09:44:00.52 spid18s ImageSKU = @imagesku,

    2012-12-11 09:44:00.52 spid18s Platform = @imagesku,

    2012-12-11 09:44:00.52 spid18s ImageSKU_Justification = @imagejustification,

    2012-12-11 09:44:00.52 spid18s OrderID = @fullorderid,

    2012-12-11 09:44:00.52 spid18s LOB = @lobname,

    2012-12-11 09:44:00.52 spid18s SubmittedToLogin = @submittedtologin,

    2012-12-11 09:44:00.52 spid18s ShipTo = @shipto,

    2012-12-11 09:44:00.52 spid18s AvailableOrders = '0',

    2012-12-11 09:44:00.52 spid18s AvailableMachines = '0',

    2012-12-11 09:44:00.52 spid18s HP_Installation = @hpinstall,

    2012-12-11 09:44:00.52 spid18s DisposalSKUQuantity = @disposalskuqty,

    2012-12-11 09:44:00.52 spid18s ExpediteDelivery = @expeditedelivery,

    2012-12-11 09:44:00.52 spid18s DeliveryInstructions = @deliveryinstructions,

    2012-12-11 09:44:00.52 spid18s eRequestNbr = @erequestnumber,

    2012-12-11 09:44:00.52 spid18s PAR_TCMS_Nbr = @partcmsnbr,

    2012-12-11 09:44:00.52 spid18s BusinessJustification = @businessjustific

    2012-12-11 09:44:00.52 spid18s inputbuf

    2012-12-11 09:44:00.52 spid18s Proc [Database Id = 6 Object Id = 1908539670]

    2012-12-11 09:44:00.52 spid18s process id=processc1ae38 taskpriority=0 logused=7920 waitresource=PAGE: 6:1:42765 waittime=2640 ownerId=2095810397 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:57.573 XDES=0x75277a88 lockMode=U schedulerid=5 kpid=11376 status=suspended spid=52 sbid=0 ecid=2 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:57.520 lastbatchcompleted=2012-12-11T09:43:57.520 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=3732 isolationlevel=read uncommitted (1) xactid=2095810397 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:44:00.52 spid18s executionStack

    2012-12-11 09:44:00.52 spid18s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:44:00.52 spid18s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:44:00.52 spid18s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.52 spid18s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:44:00.52 spid18s frame procname=BART.dbo.Upd_Po_Update_Date line=6 stmtstart=220 stmtend=536 sqlhandle=0x03000600e42911567bcd7000df9d00000000000000000000

    2012-12-11 09:44:00.52 spid18s UPDATE BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.52 spid18s SET PoUpdateDate = getdate()

    2012-12-11 09:44:00.52 spid18s FROM inserted, BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.52 spid18s WHERE BART_V3_TBL_ORDERS.WorkstationOID = Inserted.WorkstationOID

    2012-12-11 09:44:00.52 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_ACTION_UPD line=361 stmtstart=23054 stmtend=26068 sqlhandle=0x03000600c45d59684202610194a000000100000000000000

    2012-12-11 09:44:00.52 spid18s UPDATE BART_V3_TBL_Orders

    2012-12-11 09:44:00.52 spid18s SET

    2012-12-11 09:44:00.52 spid18s OrderedByLogin = @FROM_OrderedByLogin,

    2012-12-11 09:44:00.52 spid18s HardwareSKU = @FROM_HardwareSKU,

    2012-12-11 09:44:00.52 spid18s InstallSKU = @FROM_InstallSKU,

    2012-12-11 09:44:00.52 spid18s DeinstallSKU = @FROM_DeinstallSKU,

    2012-12-11 09:44:00.52 spid18s OrderType = @FROM_OrderType,

    2012-12-11 09:44:00.52 spid18s Platform = @FROM_Platform,

    2012-12-11 09:44:00.52 spid18s OrderStatus = @FROM_OrderStatus,

    2012-12-11 09:44:00.52 spid18s OrderDate = @FROM_OrderDate,

    2012-12-11 09:44:00.52 spid18s ImageSKU = @FROM_ImageSKU,

    2012-12-11 09:44:00.52 spid18s OrderID = @FROM_OrderID,

    2012-12-11 09:44:00.52 spid18s OrderIDP = @FROM_OrderIDP,

    2012-12-11 09:44:00.52 spid18s LOB = @FROM_LOB,

    2012-12-11 09:44:00.52 spid18s SubmittedByLogin = @FROM_SubmittedByLogin,

    2012-12-11 09:44:00.52 spid18s SubmittedDate = @FROM_SubmittedDate,

    2012-12-11 09:44:00.52 spid18s SubmittedToCOGDate = @FROM_SubmittedToCOGDate,

    2012-12-11 09:44:00.52 spid18s AvailableOrders = @FROM_AvailableOrders,

    2012-12-11 09:44:00.52 spid18s AvailableMachines = @FROM_AvailableMachines,

    2012-12-11 09:44:00.52 spid18s POnumber = @FROM_POnumber,

    2012-12-11 09:44:00.52 spid18s POdate = @FROM_POdate,

    2012-12-11 09:44:00.52 spid18s COGclerk = @FROM_COGclerk,

    2012-12-11 09:44:00.52 spid18s SVCnumber = @FROM_SVCnumber,

    2012-12-11 09:44:00.52 spid18s DELLnumber = @FROM_DELLnumber,

    2012-12-11 09:44:00.52 spid18s PoUpdateSource = @FROM_PoUpdateSource,

    2012-12-11 09:44:00.52 spid18s PoUpdateDate = @FROM_PoUpdateDate,

    2012-12-11 09:44:00.52 spid18s COGclerkAssigned = @FROM_COGclerkAssigned,

    2012-12-11 09:44:00.52 spid18s TrackingInfo = @FROM_TrackingInfo,

    2012-12-11 09:44:00.52 spid18s DeliveryInstructions = @FROM_DeliveryInstructions,

    2012-12-11 09:44:00.52 spid18s BusinessJustification = @FROM_Bu

    2012-12-11 09:44:00.52 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_QUEUE_UPD line=32 stmtstart=1694 stmtend=1866 sqlhandle=0x0300060058c22d35ec526600679d00000100000000000000

    2012-12-11 09:44:00.52 spid18s EXEC BART_SP_REFRESH_PRMOVE_ACTION_UPD @FROM_TRACKINGNUMBER, @TO_TRACKINGNUMBER

    2012-12-11 09:44:00.52 spid18s inputbuf

    2012-12-11 09:44:00.52 spid18s process id=processdb14c8 taskpriority=0 logused=7920 waitresource=PAGE: 6:1:39599 waittime=2656 ownerId=2095810397 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:57.573 XDES=0x5867be60 lockMode=U schedulerid=6 kpid=11128 status=suspended spid=52 sbid=0 ecid=6 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:57.520 lastbatchcompleted=2012-12-11T09:43:57.520 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=3732 isolationlevel=read uncommitted (1) xactid=2095810397 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:44:00.52 spid18s executionStack

    2012-12-11 09:44:00.52 spid18s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:44:00.52 spid18s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:44:00.52 spid18s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.52 spid18s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:44:00.52 spid18s frame procname=BART.dbo.Upd_Po_Update_Date line=6 stmtstart=220 stmtend=536 sqlhandle=0x03000600e42911567bcd7000df9d00000000000000000000

    2012-12-11 09:44:00.52 spid18s UPDATE BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.52 spid18s SET PoUpdateDate = getdate()

    2012-12-11 09:44:00.52 spid18s FROM inserted, BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.52 spid18s WHERE BART_V3_TBL_ORDERS.WorkstationOID = Inserted.WorkstationOID

    2012-12-11 09:44:00.52 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_ACTION_UPD line=361 stmtstart=23054 stmtend=26068 sqlhandle=0x03000600c45d59684202610194a000000100000000000000

    2012-12-11 09:44:00.52 spid18s UPDATE BART_V3_TBL_Orders

    2012-12-11 09:44:00.52 spid18s SET

    2012-12-11 09:44:00.52 spid18s OrderedByLogin = @FROM_OrderedByLogin,

    2012-12-11 09:44:00.52 spid18s HardwareSKU = @FROM_HardwareSKU,

    2012-12-11 09:44:00.52 spid18s InstallSKU = @FROM_InstallSKU,

    2012-12-11 09:44:00.52 spid18s DeinstallSKU = @FROM_DeinstallSKU,

    2012-12-11 09:44:00.52 spid18s OrderType = @FROM_OrderType,

    2012-12-11 09:44:00.52 spid18s Platform = @FROM_Platform,

    2012-12-11 09:44:00.52 spid18s OrderStatus = @FROM_OrderStatus,

    2012-12-11 09:44:00.52 spid18s OrderDate = @FROM_OrderDate,

    2012-12-11 09:44:00.52 spid18s ImageSKU = @FROM_ImageSKU,

    2012-12-11 09:44:00.52 spid18s OrderID = @FROM_OrderID,

    2012-12-11 09:44:00.52 spid18s OrderIDP = @FROM_OrderIDP,

    2012-12-11 09:44:00.52 spid18s LOB = @FROM_LOB,

    2012-12-11 09:44:00.52 spid18s SubmittedByLogin = @FROM_SubmittedByLogin,

    2012-12-11 09:44:00.52 spid18s SubmittedDate = @FROM_SubmittedDate,

    2012-12-11 09:44:00.52 spid18s SubmittedToCOGDate = @FROM_SubmittedToCOGDate,

    2012-12-11 09:44:00.52 spid18s AvailableOrders = @FROM_AvailableOrders,

    2012-12-11 09:44:00.52 spid18s AvailableMachines = @FROM_AvailableMachines,

    2012-12-11 09:44:00.52 spid18s POnumber = @FROM_POnumber,

    2012-12-11 09:44:00.52 spid18s POdate = @FROM_POdate,

    2012-12-11 09:44:00.52 spid18s COGclerk = @FROM_COGclerk,

    2012-12-11 09:44:00.52 spid18s SVCnumber = @FROM_SVCnumber,

    2012-12-11 09:44:00.52 spid18s DELLnumber = @FROM_DELLnumber,

    2012-12-11 09:44:00.52 spid18s PoUpdateSource = @FROM_PoUpdateSource,

    2012-12-11 09:44:00.52 spid18s PoUpdateDate = @FROM_PoUpdateDate,

    2012-12-11 09:44:00.52 spid18s COGclerkAssigned = @FROM_COGclerkAssigned,

    2012-12-11 09:44:00.52 spid18s TrackingInfo = @FROM_TrackingInfo,

    2012-12-11 09:44:00.52 spid18s DeliveryInstructions = @FROM_DeliveryInstructions,

    2012-12-11 09:44:00.52 spid18s BusinessJustification = @FROM_Bu

    2012-12-11 09:44:00.52 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_QUEUE_UPD line=32 stmtstart=1694 stmtend=1866 sqlhandle=0x0300060058c22d35ec526600679d00000100000000000000

    2012-12-11 09:44:00.52 spid18s EXEC BART_SP_REFRESH_PRMOVE_ACTION_UPD @FROM_TRACKINGNUMBER, @TO_TRACKINGNUMBER

    2012-12-11 09:44:00.52 spid18s inputbuf

    2012-12-11 09:44:00.52 spid18s process id=processdc7108 taskpriority=0 logused=7920 waitresource=PAGE: 6:3:77 waittime=2656 ownerId=2095810397 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:57.573 XDES=0x4e3c62d0 lockMode=U schedulerid=7 kpid=10392 status=suspended spid=52 sbid=0 ecid=8 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:57.520 lastbatchcompleted=2012-12-11T09:43:57.520 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=3732 isolationlevel=read uncommitted (1) xactid=2095810397 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:44:00.52 spid18s executionStack

    2012-12-11 09:44:00.52 spid18s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:44:00.52 spid18s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:44:00.52 spid18s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.52 spid18s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:44:00.52 spid18s frame procname=BART.dbo.Upd_Po_Update_Date line=6 stmtstart=220 stmtend=536 sqlhandle=0x03000600e42911567bcd7000df9d00000000000000000000

    2012-12-11 09:44:00.52 spid18s UPDATE BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.52 spid18s SET PoUpdateDate = getdate()

    2012-12-11 09:44:00.52 spid18s FROM inserted, BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.52 spid18s WHERE BART_V3_TBL_ORDERS.WorkstationOID = Inserted.WorkstationOID

    2012-12-11 09:44:00.52 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_ACTION_UPD line=361 stmtstart=23054 stmtend=26068 sqlhandle=0x03000600c45d59684202610194a000000100000000000000

    2012-12-11 09:44:00.52 spid18s UPDATE BART_V3_TBL_Orders

    2012-12-11 09:44:00.52 spid18s SET

    2012-12-11 09:44:00.52 spid18s OrderedByLogin = @FROM_OrderedByLogin,

    2012-12-11 09:44:00.52 spid18s HardwareSKU = @FROM_HardwareSKU,

    2012-12-11 09:44:00.52 spid18s InstallSKU = @FROM_InstallSKU,

    2012-12-11 09:44:00.52 spid18s DeinstallSKU = @FROM_DeinstallSKU,

    2012-12-11 09:44:00.52 spid18s OrderType = @FROM_OrderType,

    2012-12-11 09:44:00.52 spid18s Platform = @FROM_Platform,

    2012-12-11 09:44:00.52 spid18s OrderStatus = @FROM_OrderStatus,

    2012-12-11 09:44:00.52 spid18s OrderDate = @FROM_OrderDate,

    2012-12-11 09:44:00.52 spid18s ImageSKU = @FROM_ImageSKU,

    2012-12-11 09:44:00.52 spid18s OrderID = @FROM_OrderID,

    2012-12-11 09:44:00.52 spid18s OrderIDP = @FROM_OrderIDP,

    2012-12-11 09:44:00.52 spid18s LOB = @FROM_LOB,

    2012-12-11 09:44:00.52 spid18s SubmittedByLogin = @FROM_SubmittedByLogin,

    2012-12-11 09:44:00.52 spid18s SubmittedDate = @FROM_SubmittedDate,

    2012-12-11 09:44:00.52 spid18s SubmittedToCOGDate = @FROM_SubmittedToCOGDate,

    2012-12-11 09:44:00.52 spid18s AvailableOrders = @FROM_AvailableOrders,

    2012-12-11 09:44:00.52 spid18s AvailableMachines = @FROM_AvailableMachines,

    2012-12-11 09:44:00.52 spid18s POnumber = @FROM_POnumber,

    2012-12-11 09:44:00.52 spid18s POdate = @FROM_POdate,

    2012-12-11 09:44:00.52 spid18s COGclerk = @FROM_COGclerk,

    2012-12-11 09:44:00.52 spid18s SVCnumber = @FROM_SVCnumber,

    2012-12-11 09:44:00.52 spid18s DELLnumber = @FROM_DELLnumber,

    2012-12-11 09:44:00.53 spid18s PoUpdateSource = @FROM_PoUpdateSource,

    2012-12-11 09:44:00.53 spid18s PoUpdateDate = @FROM_PoUpdateDate,

    2012-12-11 09:44:00.53 spid18s COGclerkAssigned = @FROM_COGclerkAssigned,

    2012-12-11 09:44:00.53 spid18s TrackingInfo = @FROM_TrackingInfo,

    2012-12-11 09:44:00.53 spid18s DeliveryInstructions = @FROM_DeliveryInstructions,

    2012-12-11 09:44:00.53 spid18s BusinessJustification = @FROM_Bu

    2012-12-11 09:44:00.53 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_QUEUE_UPD line=32 stmtstart=1694 stmtend=1866 sqlhandle=0x0300060058c22d35ec526600679d00000100000000000000

    2012-12-11 09:44:00.53 spid18s EXEC BART_SP_REFRESH_PRMOVE_ACTION_UPD @FROM_TRACKINGNUMBER, @TO_TRACKINGNUMBER

    2012-12-11 09:44:00.53 spid18s inputbuf

    2012-12-11 09:44:00.53 spid18s process id=processdc7a68 taskpriority=0 logused=6320 waitresource=PAGE: 6:1:1757622 waittime=1750 ownerId=2095809566 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:56.043 XDES=0x5bb19e68 lockMode=U schedulerid=7 kpid=9300 status=suspended spid=70 sbid=0 ecid=8 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:56.043 lastbatchcompleted=2012-12-11T09:43:56.043 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=4240 isolationlevel=read uncommitted (1) xactid=2095809566 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:44:00.53 spid18s executionStack

    2012-12-11 09:44:00.53 spid18s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:44:00.53 spid18s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:44:00.53 spid18s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.53 spid18s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:44:00.53 spid18s frame procname=BART.dbo.BART_SP_PROCESS_ORDER_UPD line=71 stmtstart=5554 stmtend=8368 sqlhandle=0x030006001601c27115125c011da000000100000000000000

    2012-12-11 09:44:00.53 spid18s UPDATE BART_V3_TBL_Orders WITH (ROWLOCK)

    2012-12-11 09:44:00.53 spid18s SET

    2012-12-11 09:44:00.53 spid18s OrderIDP = @orderidp,

    2012-12-11 09:44:00.53 spid18s OrderedByLogin = @orderedbylogin,

    2012-12-11 09:44:00.53 spid18s HardwareSKU = @hardwaresku,

    2012-12-11 09:44:00.53 spid18s InstallSKU = @installsku,

    2012-12-11 09:44:00.53 spid18s DeinstallSKU = @deinstallsku,

    2012-12-11 09:44:00.53 spid18s OrderType = @ordertype,

    2012-12-11 09:44:00.53 spid18s OrderStatus = 'O',

    2012-12-11 09:44:00.53 spid18s OrderDate = @orderdate,

    2012-12-11 09:44:00.53 spid18s ImageSKU = @imagesku,

    2012-12-11 09:44:00.53 spid18s Platform = @imagesku,

    2012-12-11 09:44:00.53 spid18s ImageSKU_Justification = @imagejustification,

    2012-12-11 09:44:00.53 spid18s OrderID = @fullorderid,

    2012-12-11 09:44:00.53 spid18s LOB = @lobname,

    2012-12-11 09:44:00.53 spid18s SubmittedToLogin = @submittedtologin,

    2012-12-11 09:44:00.53 spid18s ShipTo = @shipto,

    2012-12-11 09:44:00.53 spid18s AvailableOrders = '0',

    2012-12-11 09:44:00.53 spid18s AvailableMachines = '0',

    2012-12-11 09:44:00.53 spid18s HP_Installation = @hpinstall,

    2012-12-11 09:44:00.53 spid18s DisposalSKUQuantity = @disposalskuqty,

    2012-12-11 09:44:00.53 spid18s ExpediteDelivery = @expeditedelivery,

    2012-12-11 09:44:00.53 spid18s DeliveryInstructions = @deliveryinstructions,

    2012-12-11 09:44:00.53 spid18s eRequestNbr = @erequestnumber,

    2012-12-11 09:44:00.53 spid18s PAR_TCMS_Nbr = @partcmsnbr,

    2012-12-11 09:44:00.53 spid18s BusinessJustification = @businessjustific

    2012-12-11 09:44:00.53 spid18s inputbuf

    2012-12-11 09:44:00.53 spid18s process id=processedcb68 taskpriority=0 logused=7920 waitresource=PAGE: 6:1:34110 waittime=2656 ownerId=2095810397 transactionname=UPDATE lasttranstarted=2012-12-11T09:43:57.573 XDES=0x5a91f7f8 lockMode=U schedulerid=8 kpid=8936 status=suspended spid=52 sbid=0 ecid=3 priority=0 transcount=0 lastbatchstarted=2012-12-11T09:43:57.520 lastbatchcompleted=2012-12-11T09:43:57.520 clientapp=.Net SqlClient Data Provider hostname=B000D60C99E78 hostpid=3732 isolationlevel=read uncommitted (1) xactid=2095810397 currentdb=6 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

    2012-12-11 09:44:00.53 spid18s executionStack

    2012-12-11 09:44:00.53 spid18s frame procname=BART.dbo.TR_BART_V3_TBL_ORDERS_DateLastChanged line=3 stmtstart=202 sqlhandle=0x030006005672f95783cd7000df9d00000000000000000000

    2012-12-11 09:44:00.53 spid18s UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    2012-12-11 09:44:00.53 spid18s FROM BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.53 spid18s INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    2012-12-11 09:44:00.53 spid18s frame procname=BART.dbo.Upd_Po_Update_Date line=6 stmtstart=220 stmtend=536 sqlhandle=0x03000600e42911567bcd7000df9d00000000000000000000

    2012-12-11 09:44:00.53 spid18s UPDATE BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.53 spid18s SET PoUpdateDate = getdate()

    2012-12-11 09:44:00.53 spid18s FROM inserted, BART_V3_TBL_ORDERS

    2012-12-11 09:44:00.53 spid18s WHERE BART_V3_TBL_ORDERS.WorkstationOID = Inserted.WorkstationOID

    2012-12-11 09:44:00.53 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_ACTION_UPD line=361 stmtstart=23054 stmtend=26068 sqlhandle=0x03000600c45d59684202610194a000000100000000000000

    2012-12-11 09:44:00.53 spid18s UPDATE BART_V3_TBL_Orders

    2012-12-11 09:44:00.53 spid18s SET

    2012-12-11 09:44:00.53 spid18s OrderedByLogin = @FROM_OrderedByLogin,

    2012-12-11 09:44:00.53 spid18s HardwareSKU = @FROM_HardwareSKU,

    2012-12-11 09:44:00.53 spid18s InstallSKU = @FROM_InstallSKU,

    2012-12-11 09:44:00.53 spid18s DeinstallSKU = @FROM_DeinstallSKU,

    2012-12-11 09:44:00.53 spid18s OrderType = @FROM_OrderType,

    2012-12-11 09:44:00.53 spid18s Platform = @FROM_Platform,

    2012-12-11 09:44:00.53 spid18s OrderStatus = @FROM_OrderStatus,

    2012-12-11 09:44:00.53 spid18s OrderDate = @FROM_OrderDate,

    2012-12-11 09:44:00.53 spid18s ImageSKU = @FROM_ImageSKU,

    2012-12-11 09:44:00.53 spid18s OrderID = @FROM_OrderID,

    2012-12-11 09:44:00.53 spid18s OrderIDP = @FROM_OrderIDP,

    2012-12-11 09:44:00.53 spid18s LOB = @FROM_LOB,

    2012-12-11 09:44:00.53 spid18s SubmittedByLogin = @FROM_SubmittedByLogin,

    2012-12-11 09:44:00.53 spid18s SubmittedDate = @FROM_SubmittedDate,

    2012-12-11 09:44:00.53 spid18s SubmittedToCOGDate = @FROM_SubmittedToCOGDate,

    2012-12-11 09:44:00.53 spid18s AvailableOrders = @FROM_AvailableOrders,

    2012-12-11 09:44:00.53 spid18s AvailableMachines = @FROM_AvailableMachines,

    2012-12-11 09:44:00.53 spid18s POnumber = @FROM_POnumber,

    2012-12-11 09:44:00.53 spid18s POdate = @FROM_POdate,

    2012-12-11 09:44:00.53 spid18s COGclerk = @FROM_COGclerk,

    2012-12-11 09:44:00.53 spid18s SVCnumber = @FROM_SVCnumber,

    2012-12-11 09:44:00.53 spid18s DELLnumber = @FROM_DELLnumber,

    2012-12-11 09:44:00.53 spid18s PoUpdateSource = @FROM_PoUpdateSource,

    2012-12-11 09:44:00.53 spid18s PoUpdateDate = @FROM_PoUpdateDate,

    2012-12-11 09:44:00.53 spid18s COGclerkAssigned = @FROM_COGclerkAssigned,

    2012-12-11 09:44:00.53 spid18s TrackingInfo = @FROM_TrackingInfo,

    2012-12-11 09:44:00.53 spid18s DeliveryInstructions = @FROM_DeliveryInstructions,

    2012-12-11 09:44:00.53 spid18s BusinessJustification = @FROM_Bu

    2012-12-11 09:44:00.53 spid18s frame procname=BART.dbo.BART_SP_REFRESH_PRMOVE_QUEUE_UPD line=32 stmtstart=1694 stmtend=1866 sqlhandle=0x0300060058c22d35ec526600679d00000100000000000000

    2012-12-11 09:44:00.53 spid18s EXEC BART_SP_REFRESH_PRMOVE_ACTION_UPD @FROM_TRACKINGNUMBER, @TO_TRACKINGNUMBER

    2012-12-11 09:44:00.53 spid18s inputbuf

    2012-12-11 09:44:00.53 spid18s resource-list

    2012-12-11 09:44:00.53 spid18s pagelock fileid=1 pageid=39479 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock143ac0c0 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:44:00.53 spid18s owner-list

    2012-12-11 09:44:00.53 spid18s owner id=processdc7a68 mode=U

    2012-12-11 09:44:00.53 spid18s waiter-list

    2012-12-11 09:44:00.53 spid18s waiter id=processb854c8 mode=U requestType=wait

    2012-12-11 09:44:00.53 spid18s exchangeEvent id=port1413cd00 nodeId=4

    2012-12-11 09:44:00.53 spid18s owner-list

    2012-12-11 09:44:00.53 spid18s owner event=e_waitNone type=producer id=process8df108

    2012-12-11 09:44:00.53 spid18s owner event=e_waitNone type=producer id=processc1ae38

    2012-12-11 09:44:00.53 spid18s owner event=e_waitNone type=producer id=processedcb68

    2012-12-11 09:44:00.53 spid18s owner event=e_waitNone type=producer id=processb854c8

    2012-12-11 09:44:00.53 spid18s owner event=e_waitNone type=producer id=process84a988

    2012-12-11 09:44:00.53 spid18s owner event=e_waitNone type=producer id=processdb14c8

    2012-12-11 09:44:00.53 spid18s owner event=e_waitNone type=producer id=process8d9a68

    2012-12-11 09:44:00.53 spid18s owner event=e_waitNone type=producer id=processdc7108

    2012-12-11 09:44:00.53 spid18s waiter-list

    2012-12-11 09:44:00.53 spid18s waiter event=e_waitPipeGetRow type=consumer id=process8d9978

    2012-12-11 09:44:00.53 spid18s pagelock fileid=1 pageid=1757622 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock72b75d80 mode=IX associatedObjectId=72057603290365952

    2012-12-11 09:44:00.53 spid18s owner-list

    2012-12-11 09:44:00.53 spid18s owner id=process8d9978 mode=IX

    2012-12-11 09:44:00.53 spid18s waiter-list

    2012-12-11 09:44:00.53 spid18s waiter id=processdc7a68 mode=U requestType=wait

    2012-12-11 09:44:00.53 spid18s exchangeEvent id=port1413d300 nodeId=4

    2012-12-11 09:44:00.53 spid18s owner-list

    2012-12-11 09:44:00.53 spid18s owner event=e_waitNone type=producer id=processdc7a68

    2012-12-11 09:44:00.53 spid18s waiter-list

    2012-12-11 09:44:00.53 spid18s waiter event=e_waitPipeGetRow type=consumer id=processc1ab68

    2012-12-11 09:44:00.53 spid18s pagelock fileid=1 pageid=42765 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock253c6300 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:44:00.53 spid18s owner-list

    2012-12-11 09:44:00.53 spid18s owner id=processc1ab68 mode=U

    2012-12-11 09:44:00.53 spid18s waiter-list

    2012-12-11 09:44:00.53 spid18s waiter id=processc1ae38 mode=U requestType=wait

    2012-12-11 09:44:00.53 spid18s pagelock fileid=1 pageid=34110 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock253c3c00 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:44:00.53 spid18s owner-list

    2012-12-11 09:44:00.53 spid18s owner id=processc1ab68 mode=U

    2012-12-11 09:44:00.53 spid18s owner id=processc1ab68 mode=U

    2012-12-11 09:44:00.53 spid18s waiter-list

    2012-12-11 09:44:00.53 spid18s waiter id=processedcb68 mode=U requestType=wait

    2012-12-11 09:44:00.53 spid18s pagelock fileid=3 pageid=77 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock39c92f40 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:44:00.53 spid18s owner-list

    2012-12-11 09:44:00.53 spid18s owner id=processc1ab68 mode=U

    2012-12-11 09:44:00.53 spid18s waiter-list

    2012-12-11 09:44:00.53 spid18s waiter id=processdc7108 mode=U requestType=wait

    2012-12-11 09:44:00.53 spid18s pagelock fileid=1 pageid=39599 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock3b9fa680 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:44:00.53 spid18s owner-list

    2012-12-11 09:44:00.53 spid18s owner id=processc1ab68 mode=U

    2012-12-11 09:44:00.53 spid18s owner id=processc1ab68 mode=U

    2012-12-11 09:44:00.53 spid18s waiter-list

    2012-12-11 09:44:00.53 spid18s waiter id=processdb14c8 mode=U requestType=wait

    2012-12-11 09:44:00.53 spid18s pagelock fileid=1 pageid=23991 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock603461c0 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:44:00.53 spid18s owner-list

    2012-12-11 09:44:00.53 spid18s owner id=processc1ab68 mode=U

    2012-12-11 09:44:00.53 spid18s owner id=processc1ab68 mode=U

    2012-12-11 09:44:00.53 spid18s waiter-list

    2012-12-11 09:44:00.53 spid18s waiter id=process8df108 mode=U requestType=wait

    2012-12-11 09:44:00.53 spid18s pagelock fileid=3 pageid=715812 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock72a601c0 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:44:00.53 spid18s owner-list

    2012-12-11 09:44:00.53 spid18s owner id=processc1ab68 mode=U

    2012-12-11 09:44:00.53 spid18s owner id=processc1ab68 mode=U

    2012-12-11 09:44:00.53 spid18s waiter-list

    2012-12-11 09:44:00.53 spid18s waiter id=process84a988 mode=U requestType=wait

    2012-12-11 09:44:00.53 spid18s pagelock fileid=1 pageid=23752 dbid=6 objectname=BART.dbo.BART_V3_TBL_Orders id=lock7664f280 mode=U associatedObjectId=72057603290365952

    2012-12-11 09:44:00.53 spid18s owner-list

    2012-12-11 09:44:00.53 spid18s owner id=processc1ab68 mode=U

    2012-12-11 09:44:00.53 spid18s waiter-list

    2012-12-11 09:44:00.53 spid18s waiter id=process8d9a68 mode=U requestType=wait

  • All right, so if we discard all the parallelism mess (which is mostly irrelevant noise), we have this:

    spid=52, running a statement within a trigger

    UPDATE BART_V3_TBL_ORDERS SET BART_V3_TBL_ORDERS.DateLastChanged = GETDATE()

    FROM BART_V3_TBL_ORDERS

    INNER JOIN Inserted ON BART_V3_TBL_ORDERS.RecordID = Inserted.RecordID

    spid=70, running the same statement within in the trigger.

    I suspect part of the problem is the rowlock hint. The trigger doesn't have any locking hints and is locking at the page level. If two of those update statements try to run on rows on the same page, the updates will be fine (they both lock rows), the trigger tries to take page locks and you end up with a deadlock as the two triggers wait for the other update to release the IX lock, which of course can't happen.

    If you take the rowlock hint off, does the deadlock still happen?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • We have very harsh change control rules. I will have to check to see if that can be performed as part of our troubleshooting. I have to say I ignored the trigger, since it was also single a record update. Let me see if I can repeat your explanation - so I can pass it on.

    The issue is from the trigger causing lock escalation, along with the WITH ROW LOCK hint on the Update Orders code getting an Exclusive Lock. The recommendation is to remove the WITH ROW LOCK hint to see if the processes involved simply wait their turn to access the table and perform the updates in an orderly fashion.

    Is there any benefit to addressing the trigger code, itself?

    Thanks for your help.

  • Craigmeister (12/17/2012)


    The issue is from the trigger causing lock escalation,

    No, the trigger is not causing lock escalation. Lock escalation is to table always, we're dealing with page and row locks here.

    The initial update takes locks. These will be row locks because of the hint. These locks are taken as update and then converted to exclusive for the actual update. The exclusive lock is at the row level, but there will be IX locks at the page and table level.

    The trigger then fires. It runs within the same transaction as the update that fires it. The update in the trigger then requests update locks. There's no hint and the query execution engine determines that page locks will be the optimal.

    If there is another of these updates running in another session, the trigger's lock request cannot be granted as that other session has an exclusive row lock (and the page-level IX lock) and a U lock is not compatible with the page level IX. Hence the trigger's execution is blocked and waits.

    The second update then completes and fires its trigger. Again the trigger requests a page-level U lock, this is blocked by the first session's update and we have a deadlock.

    What indexes are on the RecordID, WorkstationOID and trackingnumber columns?

    Do you really need to have multiple update triggers on the same table? Can they not be combined into one?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (12/17/2012)


    What indexes are on the RecordID, WorkstationOID and trackingnumber columns?

    Do you really need to have multiple update triggers on the same table? Can they not be combined into one?

    There are several indexes that contain the WorkstationOID and trackingnumber fields, but as I said in an earlier post, it is not pretty.

    There is a serious question about the POUPDATEDATE trigger. It should probably be included specifically in the code rather than by trigger. There are fields in the Orders table not represented here that are updated, so the DateLastChanged update by itself is "needed." These both will be included in the planned redesign. But there is no reason why they could not be combined.

    Would you say this is an issue of these processes not being optimized so they are not completing fast enough and thus trip on each other? Or is it just because of the 2 triggers firing and the "speed" doesn't necessarily matter?

    The reason I ask is I am wondering about the effect of updating 18-19 indexes for each of these Update Orders procedures and how much effort/time I need to put into pushing index redesign through vs. other possible troubleshooting efforts.

  • Craigmeister (12/17/2012)


    Would you say this is an issue of these processes not being optimized so they are not completing fast enough and thus trip on each other? Or is it just because of the 2 triggers firing and the "speed" doesn't necessarily matter?

    The longer they run, the more chance they have to deadlock, but there's still a chance of them deadlocking if they run fast.

    The reason I ask is I am wondering about the effect of updating 18-19 indexes for each of these Update Orders procedures and how much effort/time I need to put into pushing index redesign through vs. other possible troubleshooting efforts.

    Without any idea what those indexes are like, I can't comment on that.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply