June 25, 2010 at 5:40 am
Hi All
We have a SQL Job (2005) that from time to time will fail due a deadlock. The error is as follows ;
[font="Courier New"]Transaction (Process ID 52) was deadlocked on thread | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205). The step failed.[/font]
This is an overnight job which effectively loads a reporting database and perform various corrections to the data. There are no other DML statements running simultaneously. The error occurs about once a week on differing days and at different points in the data load process. So I am presuming it is not due to DML statements.
Turning on Trace Flag 1222 provides information that is next to useless. Most of the articles that I have read are related to transactions and queries and therefore locks related to data pages/tables but not many related to memory/threads/buffer resources.
I ran PerfMon with all counters that seemed relevant (Network related, Available threads, Available Work Items, Log Buffer Waits as well as the usual ones such as Processor & memory related) but there was nothing immediately obvious.
Any help would be appreciated.
Preet
June 25, 2010 at 6:01 am
You said you turned traceflag 1222 on. That means that the deadlock graph will be written to the error log.
Post it here. It may be near useless to you, but there are regular posters here who know how to read them.
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
June 25, 2010 at 6:03 am
*removed*
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
June 25, 2010 at 12:25 pm
I really wonder ,how you came to a conclusion that output you get by enabling trace flag 1222 is useless.
If you would like to learn deadlock troubleshooting and interpreting the output generated by traceflag 1222,Follow the excellent blog posts written by Bart duncan.
http://blogs.msdn.com/b/bartd/archive/2006/09/09/deadlock-troubleshooting_2c00_-part-1.aspx
June 28, 2010 at 3:29 am
There you go folks, I'd be glad to hear what useful info the log contains.
Cheers
Preet
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process7862208
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process5caf63e8
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process55a38118
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process4e95a2f8
06/21/2010 08:17:30,spid5s,Unknown,waiter-list
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process55a384d8
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process4e95a6b8
06/21/2010 08:17:30,spid5s,Unknown,owner event=e_waitNone type=producer id=process78622f8
06/21/2010 08:17:30,spid5s,Unknown,owner-list
06/21/2010 08:17:30,spid5s,Unknown,exchangeEvent id=porta152d80 nodeId=76
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process5caf64d8
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process4e95a3e8
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process55a38208
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process78622f8
06/21/2010 08:17:30,spid5s,Unknown,waiter-list
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process55a384d8
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process4e95a6b8
06/21/2010 08:17:30,spid5s,Unknown,owner event=e_waitNone type=producer id=process55a382f8
06/21/2010 08:17:30,spid5s,Unknown,owner-list
06/21/2010 08:17:30,spid5s,Unknown,exchangeEvent id=porta152b80 nodeId=79
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process4e95a4d8
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process78623e8
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process5caf65c8
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process55a382f8
06/21/2010 08:17:30,spid5s,Unknown,waiter-list
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process55a384d8
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process4e95a6b8
06/21/2010 08:17:30,spid5s,Unknown,owner event=e_waitNone type=producer id=process78624d8
06/21/2010 08:17:30,spid5s,Unknown,owner-list
06/21/2010 08:17:30,spid5s,Unknown,exchangeEvent id=porta152980 nodeId=81
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process5caf6208
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process7ffe28
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process7ebd38
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process4e95a118
06/21/2010 08:17:30,spid5s,Unknown,waiter-list
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process55a384d8
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process4e95a6b8
06/21/2010 08:17:30,spid5s,Unknown,owner event=e_waitNone type=producer id=process55a38118
06/21/2010 08:17:30,spid5s,Unknown,owner-list
06/21/2010 08:17:30,spid5s,Unknown,exchangeEvent id=porta152380 nodeId=72
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process7fea78
06/21/2010 08:17:30,spid5s,Unknown,waiter-list
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process55a384d8
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process4e95a6b8
06/21/2010 08:17:30,spid5s,Unknown,owner event=e_waitNone type=producer id=processd75d38
06/21/2010 08:17:30,spid5s,Unknown,owner-list
06/21/2010 08:17:30,spid5s,Unknown,exchangeEvent id=porta152780 nodeId=2
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process7ebf18
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process7f9f18
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process7fed48
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=processd75d38
06/21/2010 08:17:30,spid5s,Unknown,waiter-list
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process55a384d8
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process4e95a6b8
06/21/2010 08:17:30,spid5s,Unknown,owner event=e_waitNone type=producer id=processd74e38
06/21/2010 08:17:30,spid5s,Unknown,owner-list
06/21/2010 08:17:30,spid5s,Unknown,exchangeEvent id=porta152200 nodeId=59
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=processd74e38
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process7f9d38
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process7ff2e8
06/21/2010 08:17:30,spid5s,Unknown,waiter-list
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process55a384d8
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process4e95a6b8
06/21/2010 08:17:30,spid5s,Unknown,owner event=e_waitNone type=producer id=processd754c8
06/21/2010 08:17:30,spid5s,Unknown,owner-list
06/21/2010 08:17:30,spid5s,Unknown,exchangeEvent id=porta152e00 nodeId=63
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process7ffa68
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=processd754c8
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process7f8898
06/21/2010 08:17:30,spid5s,Unknown,waiter-list
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process55a384d8
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process4e95a6b8
06/21/2010 08:17:30,spid5s,Unknown,owner event=e_waitNone type=producer id=process5caf6208
06/21/2010 08:17:30,spid5s,Unknown,owner-list
06/21/2010 08:17:30,spid5s,Unknown,exchangeEvent id=porta152100 nodeId=68
06/21/2010 08:17:30,spid5s,Unknown,waiter id=process55a384d8
06/21/2010 08:17:30,spid5s,Unknown,waiter-list
06/21/2010 08:17:30,spid5s,Unknown,owner id=process7fea78
06/21/2010 08:17:30,spid5s,Unknown,owner id=process7fed48
06/21/2010 08:17:30,spid5s,Unknown,owner id=process7ff2e8
06/21/2010 08:17:30,spid5s,Unknown,owner id=process7ffa68
06/21/2010 08:17:30,spid5s,Unknown,owner id=process7ffe28
06/21/2010 08:17:30,spid5s,Unknown,owner id=process55a38118
06/21/2010 08:17:30,spid5s,Unknown,owner id=process55a38208
06/21/2010 08:17:30,spid5s,Unknown,owner id=process55a382f8
06/21/2010 08:17:30,spid5s,Unknown,owner id=process55a383e8
06/21/2010 08:17:30,spid5s,Unknown,owner-list
06/21/2010 08:17:30,spid5s,Unknown,threadpool id=schedulerce2040
06/21/2010 08:17:30,spid5s,Unknown,waiter id=process4e95a6b8
06/21/2010 08:17:30,spid5s,Unknown,waiter-list
06/21/2010 08:17:30,spid5s,Unknown,owner id=processd74e38
06/21/2010 08:17:30,spid5s,Unknown,owner id=processd754c8
06/21/2010 08:17:30,spid5s,Unknown,owner id=processd75d38
06/21/2010 08:17:30,spid5s,Unknown,owner id=process4e95a118
06/21/2010 08:17:30,spid5s,Unknown,owner id=process4e95a2f8
06/21/2010 08:17:30,spid5s,Unknown,owner id=process4e95a3e8
06/21/2010 08:17:30,spid5s,Unknown,owner id=process4e95a4d8
06/21/2010 08:17:30,spid5s,Unknown,owner id=process4e95a5c8
06/21/2010 08:17:30,spid5s,Unknown,owner-list
06/21/2010 08:17:30,spid5s,Unknown,threadpool id=schedulerd78040
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process4e95a5c8
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process55a383e8
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process78624d8
06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process5caf66b8
06/21/2010 08:17:30,spid5s,Unknown,waiter-list
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process55a384d8
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process4e95a6b8
06/21/2010 08:17:30,spid5s,Unknown,owner event=pending id=process5caf67a8
06/21/2010 08:17:30,spid5s,Unknown,owner-list
06/21/2010 08:17:30,spid5s,Unknown,exchangeEvent id=porta152f00 nodeId=84
06/21/2010 08:17:30,spid5s,Unknown,waiter id=process5caf67a8
06/21/2010 08:17:30,spid5s,Unknown,waiter-list
06/21/2010 08:17:30,spid5s,Unknown,owner id=process7f8898
06/21/2010 08:17:30,spid5s,Unknown,owner id=process7f9d38
06/21/2010 08:17:30,spid5s,Unknown,owner id=process7f9f18
06/21/2010 08:17:30,spid5s,Unknown,owner id=process5caf6208
06/21/2010 08:17:30,spid5s,Unknown,owner id=process5caf63e8
06/21/2010 08:17:30,spid5s,Unknown,owner id=process5caf64d8
06/21/2010 08:17:30,spid5s,Unknown,owner id=process5caf65c8
06/21/2010 08:17:30,spid5s,Unknown,owner id=process5caf66b8
06/21/2010 08:17:30,spid5s,Unknown,owner-list
06/21/2010 08:17:30,spid5s,Unknown,threadpool id=schedulerbd0040
06/21/2010 08:17:30,spid5s,Unknown,resource-list
06/21/2010 08:17:30,spid5s,Unknown,process id=process5caf67a8 schedulerid=2 kpid=0
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process5caf66b8 taskpriority=0 logused=20084 waittime=15 schedulerid=2 kpid=5544 status=suspended spid=52 sbid=0 ecid=30 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process5caf65c8 taskpriority=0 logused=20081 waittime=31 schedulerid=2 kpid=6576 status=suspended spid=52 sbid=0 ecid=25 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process5caf64d8 taskpriority=0 logused=20079 waittime=31 schedulerid=2 kpid=4752 status=suspended spid=52 sbid=0 ecid=21 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process5caf63e8 taskpriority=0 logused=20076 waittime=31 schedulerid=2 kpid=7312 status=suspended spid=52 sbid=0 ecid=19 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process5caf6208 taskpriority=0 logused=20072 waittime=31 schedulerid=2 kpid=1740 status=suspended spid=52 sbid=0 ecid=13 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,process id=process55a384d8 schedulerid=3 kpid=0
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process55a383e8 taskpriority=0 logused=20084 schedulerid=3 kpid=6868 status=suspended spid=52 sbid=0 ecid=31 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process55a382f8 taskpriority=0 logused=20081 waittime=31 schedulerid=3 kpid=6696 status=suspended spid=52 sbid=0 ecid=26 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process55a38208 taskpriority=0 logused=20079 waittime=31 schedulerid=3 kpid=7180 status=suspended spid=52 sbid=0 ecid=23 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process55a38118 taskpriority=0 logused=20076 waittime=31 schedulerid=3 kpid=2640 status=suspended spid=52 sbid=0 ecid=18 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,process id=process4e95a6b8 schedulerid=4 kpid=0
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process4e95a5c8 taskpriority=0 logused=20084 waittime=15 schedulerid=4 kpid=2508 status=suspended spid=52 sbid=0 ecid=32 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process4e95a4d8 taskpriority=0 logused=20081 waittime=31 schedulerid=4 kpid=6328 status=suspended spid=52 sbid=0 ecid=27 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process4e95a3e8 taskpriority=0 logused=20079 waittime=31 schedulerid=4 kpid=7264 status=suspended spid=52 sbid=0 ecid=24 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process4e95a2f8 taskpriority=0 logused=20076 waittime=31 schedulerid=4 kpid=2364 status=suspended spid=52 sbid=0 ecid=17 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process4e95a118 taskpriority=0 logused=20072 waittime=31 schedulerid=4 kpid=5508 status=suspended spid=52 sbid=0 ecid=16 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process78624d8 taskpriority=0 logused=20084 schedulerid=1 kpid=6836 status=suspended spid=52 sbid=0 ecid=29 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process78623e8 taskpriority=0 logused=20081 waittime=31 schedulerid=1 kpid=5956 status=suspended spid=52 sbid=0 ecid=28 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process78622f8 taskpriority=0 logused=20079 waittime=31 schedulerid=1 kpid=6632 status=suspended spid=52 sbid=0 ecid=22 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process7862208 taskpriority=0 logused=20076 waittime=31 schedulerid=1 kpid=7280 status=suspended spid=52 sbid=0 ecid=20 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=processd75d38 taskpriority=0 logused=20059 waittime=78 schedulerid=4 kpid=6636 status=suspended spid=52 sbid=0 ecid=15 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=processd754c8 taskpriority=0 logused=20068 waittime=46 schedulerid=4 kpid=5236 status=suspended spid=52 sbid=0 ecid=11 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=processd74e38 taskpriority=0 logused=20063 waittime=62 schedulerid=4 kpid=2312 status=suspended spid=52 sbid=0 ecid=6 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process7ffe28 taskpriority=0 logused=20072 waittime=31 schedulerid=3 kpid=6588 status=suspended spid=52 sbid=0 ecid=14 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process7ffa68 taskpriority=0 logused=20068 waittime=46 schedulerid=3 kpid=3168 status=suspended spid=52 sbid=0 ecid=10 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process7ff2e8 taskpriority=0 logused=20063 waittime=62 schedulerid=3 kpid=2444 status=suspended spid=52 sbid=0 ecid=8 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process7fed48 taskpriority=0 logused=20059 waittime=78 schedulerid=3 kpid=1376 status=suspended spid=52 sbid=0 ecid=16 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,spLoadStagingTables
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process7fea78 taskpriority=0 logused=20002 waittime=2500 schedulerid=3 kpid=5556 status=suspended spid=52 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 loginname=DM1\SQLServices isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process7f9f18 taskpriority=0 logused=20059 waittime=78 schedulerid=2 kpid=6284 status=suspended spid=52 sbid=0 ecid=13 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process7f9d38 taskpriority=0 logused=20063 waittime=62 schedulerid=2 kpid=4760 status=suspended spid=52 sbid=0 ecid=7 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process7f8898 taskpriority=0 logused=20068 waittime=46 schedulerid=2 kpid=6772 status=suspended spid=52 sbid=0 ecid=12 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process7ebf18 taskpriority=0 logused=20059 waittime=78 schedulerid=1 kpid=5052 status=suspended spid=52 sbid=0 ecid=14 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,inputbuf
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=1 sqlhandle=0x01001000004b623470f7920c000000000000000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=270 stmtstart=17844 stmtend=17912 sqlhandle=0x030010007d8c3a4087c11d01109d00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,unknown
06/21/2010 08:17:30,spid5s,Unknown,frame procname=unknown line=10 stmtstart=228 sqlhandle=0x03001000f053dc3ec1f80101269a00000100000000000000
06/21/2010 08:17:30,spid5s,Unknown,executionStack
06/21/2010 08:17:30,spid5s,Unknown,process id=process7ebd38 taskpriority=0 logused=20072 waittime=31 schedulerid=1 kpid=6208 status=suspended spid=52 sbid=0 ecid=15 priority=0 transcount=0 lastbatchstarted=2010-06-21T06:29:24.740 lastbatchcompleted=2010-06-21T06:29:24.740 clientapp=SQLAgent - TSQL JobStep (Job 0x7405EAEC43ECFD4EABFBB72FC12B3F18 : Step 1) hostname=Server1 hostpid=5536 isolationlevel=read committed (2) xactid=61047212 currentdb=16 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
06/21/2010 08:17:30,spid5s,Unknown,process-list
06/21/2010 08:17:30,spid5s,Unknown,deadlock victim=process7fea78
06/21/2010 08:17:30,spid5s,Unknown,deadlock-list
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply