Home Forums SQL Server 2008 SQL Server 2008 - General Deadlock Output RE: Deadlock Output

  • August 29, 2012 at 4:11 am

    #1531294

    HI, i found such a log related to dead lock after turning on correct trace flag.

    please suggest something if you can find out actual cause of dead lock or decode the out put and the reason of it being so long out put?

    deadlock-list

    2012-08-29 11:46:32.54 spid37s deadlock victim=process81bb88

    2012-08-29 11:46:32.54 spid37s process-list

    2012-08-29 11:46:32.54 spid37s process id=process81bb88 taskpriority=0 logused=692 waitresource=PAGE: 126:1:2431515 waittime=5720 ownerId=30340257379 transactionname=DELETE lasttranstarted=2012-08-29T11:46:26.837 XDES=0x3b79b1950 lockMode=IX schedulerid=1 kpid=18972 status=suspended spid=324 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:26.837 lastbatchcompleted=2012-08-29T11:46:26.837 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340257379 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:32.54 spid37s executionStack

    2012-08-29 11:46:32.54 spid37s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:32.54 spid37s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:32.54 spid37s inputbuf

    2012-08-29 11:46:32.54 spid37s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:32.54 spid37s process id=processa82b708 taskpriority=0 logused=33074260 waitresource=PAGE: 126:1:3138657 waittime=4866 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:32.54 spid37s executionStack

    2012-08-29 11:46:32.54 spid37s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 11:46:32.54 spid37s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 11:46:32.54 spid37s inputbuf

    2012-08-29 11:46:32.54 spid37s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 11:46:32.54 spid37s resource-list

    2012-08-29 11:46:32.54 spid37s pagelock fileid=1 pageid=2431515 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2f3bb8f80 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:32.54 spid37s owner-list

    2012-08-29 11:46:32.54 spid37s owner id=processa82b708 mode=U

    2012-08-29 11:46:32.54 spid37s waiter-list

    2012-08-29 11:46:32.54 spid37s waiter id=process81bb88 mode=IX requestType=wait

    2012-08-29 11:46:32.54 spid37s pagelock fileid=1 pageid=3138657 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock4d39c0f00 mode=IX associatedObjectId=72057594042318848

    2012-08-29 11:46:32.54 spid37s owner-list

    2012-08-29 11:46:32.54 spid37s owner id=process81bb88 mode=IX

    2012-08-29 11:46:32.54 spid37s waiter-list

    2012-08-29 11:46:32.54 spid37s waiter id=processa82b708 mode=U requestType=wait

    2012-08-29 11:46:37.56 spid17s deadlock-list

    2012-08-29 11:46:37.56 spid17s deadlock victim=process4e03dc8

    2012-08-29 11:46:37.56 spid17s process-list

    2012-08-29 11:46:37.56 spid17s process id=process4e03dc8 taskpriority=0 logused=692 waitresource=PAGE: 126:1:5148471 waittime=6087 ownerId=30340263921 transactionname=DELETE lasttranstarted=2012-08-29T11:46:31.477 XDES=0x1c51d5460 lockMode=IX schedulerid=5 kpid=7736 status=suspended spid=491 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:31.477 lastbatchcompleted=2012-08-29T11:46:31.477 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340263921 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:37.56 spid17s executionStack

    2012-08-29 11:46:37.56 spid17s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:37.56 spid17s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:37.56 spid17s inputbuf

    2012-08-29 11:46:37.56 spid17s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:37.56 spid17s process id=processa82b708 taskpriority=0 logused=33077260 waitresource=PAGE: 126:1:5212618 waittime=5005 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:37.56 spid17s executionStack

    2012-08-29 11:46:37.56 spid17s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 11:46:37.56 spid17s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 11:46:37.56 spid17s inputbuf

    2012-08-29 11:46:37.56 spid17s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 11:46:37.56 spid17s resource-list

    2012-08-29 11:46:37.56 spid17s pagelock fileid=1 pageid=5148471 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e64e1700 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:37.56 spid17s owner-list

    2012-08-29 11:46:37.56 spid17s owner id=processa82b708 mode=U

    2012-08-29 11:46:37.56 spid17s waiter-list

    2012-08-29 11:46:37.56 spid17s waiter id=process4e03dc8 mode=IX requestType=wait

    2012-08-29 11:46:37.56 spid17s pagelock fileid=1 pageid=5212618 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lockc635f280 mode=IX associatedObjectId=72057594042318848

    2012-08-29 11:46:37.56 spid17s owner-list

    2012-08-29 11:46:37.56 spid17s owner id=process4e03dc8 mode=IX

    2012-08-29 11:46:37.56 spid17s waiter-list

    2012-08-29 11:46:37.56 spid17s waiter id=processa82b708 mode=U requestType=wait

    2012-08-29 11:46:40.08 spid18s deadlock-list

    2012-08-29 11:46:40.08 spid18s deadlock victim=processa844748

    2012-08-29 11:46:40.08 spid18s process-list

    2012-08-29 11:46:40.08 spid18s process id=processa844748 taskpriority=0 logused=692 waitresource=PAGE: 126:1:5148471 waittime=6097 ownerId=30340266774 transactionname=DELETE lasttranstarted=2012-08-29T11:46:33.980 XDES=0x64ce5f950 lockMode=IX schedulerid=23 kpid=21332 status=suspended spid=392 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:33.980 lastbatchcompleted=2012-08-29T11:46:33.980 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340266774 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:40.08 spid18s executionStack

    2012-08-29 11:46:40.08 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:40.08 spid18s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:40.08 spid18s inputbuf

    2012-08-29 11:46:40.08 spid18s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:40.08 spid18s process id=process81bb88 taskpriority=0 logused=692 waitresource=PAGE: 126:1:5148471 waittime=7498 ownerId=30340265361 transactionname=DELETE lasttranstarted=2012-08-29T11:46:32.567 XDES=0x3b79b1950 lockMode=IX schedulerid=1 kpid=18972 status=suspended spid=324 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:32.567 lastbatchcompleted=2012-08-29T11:46:32.563 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340265361 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:40.08 spid18s executionStack

    2012-08-29 11:46:40.08 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:40.08 spid18s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:40.08 spid18s inputbuf

    2012-08-29 11:46:40.08 spid18s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:40.08 spid18s process id=processa82b708 taskpriority=0 logused=33085900 waitresource=PAGE: 126:1:3119884 waittime=2510 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:40.08 spid18s executionStack

    2012-08-29 11:46:40.08 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 11:46:40.08 spid18s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 11:46:40.08 spid18s inputbuf

    2012-08-29 11:46:40.08 spid18s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 11:46:40.08 spid18s resource-list

    2012-08-29 11:46:40.08 spid18s pagelock fileid=1 pageid=5148471 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e64e1700 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:40.08 spid18s owner-list

    2012-08-29 11:46:40.08 spid18s waiter-list

    2012-08-29 11:46:40.08 spid18s waiter id=processa844748 mode=IX requestType=wait

    2012-08-29 11:46:40.08 spid18s pagelock fileid=1 pageid=5148471 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e64e1700 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:40.08 spid18s owner-list

    2012-08-29 11:46:40.08 spid18s owner id=processa82b708 mode=U

    2012-08-29 11:46:40.08 spid18s waiter-list

    2012-08-29 11:46:40.08 spid18s waiter id=process81bb88 mode=IX requestType=wait

    2012-08-29 11:46:40.08 spid18s pagelock fileid=1 pageid=3119884 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock1384e7d80 mode=IX associatedObjectId=72057594042318848

    2012-08-29 11:46:40.08 spid18s owner-list

    2012-08-29 11:46:40.08 spid18s owner id=processa844748 mode=IX

    2012-08-29 11:46:40.08 spid18s waiter-list

    2012-08-29 11:46:40.08 spid18s waiter id=processa82b708 mode=U requestType=wait

    2012-08-29 11:46:41.34 spid25s deadlock-list

    2012-08-29 11:46:41.34 spid25s deadlock victim=process81bb88

    2012-08-29 11:46:41.34 spid25s process-list

    2012-08-29 11:46:41.34 spid25s process id=process81bb88 taskpriority=0 logused=692 waitresource=PAGE: 126:1:5148471 waittime=8761 ownerId=30340265361 transactionname=DELETE lasttranstarted=2012-08-29T11:46:32.567 XDES=0x3b79b1950 lockMode=IX schedulerid=1 kpid=18972 status=suspended spid=324 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:32.567 lastbatchcompleted=2012-08-29T11:46:32.563 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340265361 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:41.34 spid25s executionStack

    2012-08-29 11:46:41.34 spid25s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:41.34 spid25s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:41.34 spid25s inputbuf

    2012-08-29 11:46:41.34 spid25s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:41.34 spid25s process id=processa82b708 taskpriority=0 logused=33089380 waitresource=PAGE: 126:1:5216891 waittime=1262 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:41.34 spid25s executionStack

    2012-08-29 11:46:41.34 spid25s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 11:46:41.34 spid25s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 11:46:41.34 spid25s inputbuf

    2012-08-29 11:46:41.34 spid25s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 11:46:41.34 spid25s resource-list

    2012-08-29 11:46:41.34 spid25s pagelock fileid=1 pageid=5148471 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e64e1700 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:41.34 spid25s owner-list

    2012-08-29 11:46:41.34 spid25s owner id=processa82b708 mode=U

    2012-08-29 11:46:41.34 spid25s waiter-list

    2012-08-29 11:46:41.34 spid25s waiter id=process81bb88 mode=IX requestType=wait

    2012-08-29 11:46:41.34 spid25s pagelock fileid=1 pageid=5216891 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock49aa90580 mode=IX associatedObjectId=72057594042318848

    2012-08-29 11:46:41.34 spid25s owner-list

    2012-08-29 11:46:41.34 spid25s owner id=process81bb88 mode=IX

    2012-08-29 11:46:41.34 spid25s waiter-list

    2012-08-29 11:46:41.34 spid25s waiter id=processa82b708 mode=U requestType=wait

    2012-08-29 11:46:41.97 spid17s deadlock-list

    2012-08-29 11:46:41.97 spid17s deadlock victim=process5acf4c8

    2012-08-29 11:46:41.97 spid17s process-list

    2012-08-29 11:46:41.97 spid17s process id=process5acf4c8 taskpriority=0 logused=692 waitresource=PAGE: 126:1:2431514 waittime=17391 ownerId=30340252457 transactionname=DELETE lasttranstarted=2012-08-29T11:46:24.580 XDES=0x13720f250 lockMode=IX schedulerid=16 kpid=20276 status=suspended spid=138 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:24.580 lastbatchcompleted=2012-08-29T11:46:24.580 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340252457 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:41.97 spid17s executionStack

    2012-08-29 11:46:41.97 spid17s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:41.97 spid17s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:41.97 spid17s inputbuf

    2012-08-29 11:46:41.97 spid17s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:41.97 spid17s process id=processa82b708 taskpriority=0 logused=33099220 waitresource=PAGE: 126:1:3139426 waittime=638 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:41.97 spid17s executionStack

    2012-08-29 11:46:41.97 spid17s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 11:46:41.97 spid17s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 11:46:41.97 spid17s inputbuf

    2012-08-29 11:46:41.97 spid17s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 11:46:41.97 spid17s resource-list

    2012-08-29 11:46:41.97 spid17s pagelock fileid=1 pageid=2431514 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6517680 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:41.97 spid17s owner-list

    2012-08-29 11:46:41.97 spid17s owner id=processa82b708 mode=U

    2012-08-29 11:46:41.97 spid17s waiter-list

    2012-08-29 11:46:41.97 spid17s waiter id=process5acf4c8 mode=IX requestType=wait

    2012-08-29 11:46:41.97 spid17s pagelock fileid=1 pageid=3139426 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e67de900 mode=IX associatedObjectId=72057594042318848

    2012-08-29 11:46:41.97 spid17s owner-list

    2012-08-29 11:46:41.97 spid17s owner id=process5acf4c8 mode=IX

    2012-08-29 11:46:41.97 spid17s waiter-list

    2012-08-29 11:46:41.97 spid17s waiter id=processa82b708 mode=U requestType=wait

    2012-08-29 11:46:42.28 spid18s deadlock-list

    2012-08-29 11:46:42.28 spid18s deadlock victim=process4de8988

    2012-08-29 11:46:42.28 spid18s process-list

    2012-08-29 11:46:42.28 spid18s process id=process4de8988 taskpriority=0 logused=692 waitresource=PAGE: 126:1:2431514 waittime=11874 ownerId=30340262531 transactionname=DELETE lasttranstarted=2012-08-29T11:46:30.403 XDES=0x727af1950 lockMode=IX schedulerid=4 kpid=5044 status=suspended spid=489 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:30.403 lastbatchcompleted=2012-08-29T11:46:30.400 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340262531 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.28 spid18s executionStack

    2012-08-29 11:46:42.28 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:42.28 spid18s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:42.28 spid18s inputbuf

    2012-08-29 11:46:42.28 spid18s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:42.28 spid18s process id=processa82b708 taskpriority=0 logused=33104020 waitresource=PAGE: 126:1:5218673 waittime=309 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.28 spid18s executionStack

    2012-08-29 11:46:42.28 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 11:46:42.28 spid18s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 11:46:42.28 spid18s inputbuf

    2012-08-29 11:46:42.28 spid18s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 11:46:42.28 spid18s resource-list

    2012-08-29 11:46:42.28 spid18s pagelock fileid=1 pageid=2431514 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6517680 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:42.28 spid18s owner-list

    2012-08-29 11:46:42.28 spid18s owner id=processa82b708 mode=U

    2012-08-29 11:46:42.28 spid18s waiter-list

    2012-08-29 11:46:42.28 spid18s waiter id=process4de8988 mode=IX requestType=wait

    2012-08-29 11:46:42.28 spid18s pagelock fileid=1 pageid=5218673 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lockb654ad00 mode=IX associatedObjectId=72057594042318848

    2012-08-29 11:46:42.28 spid18s owner-list

    2012-08-29 11:46:42.28 spid18s owner id=process4de8988 mode=IX

    2012-08-29 11:46:42.28 spid18s waiter-list

    2012-08-29 11:46:42.28 spid18s waiter id=processa82b708 mode=U requestType=wait

    2012-08-29 11:46:42.44 spid37s deadlock-list

    2012-08-29 11:46:42.44 spid37s deadlock victim=process5ac5708

    2012-08-29 11:46:42.44 spid37s process-list

    2012-08-29 11:46:42.44 spid37s process id=process5ac5708 taskpriority=0 logused=692 waitresource=PAGE: 126:1:2431514 waittime=7412 ownerId=30340268315 transactionname=DELETE lasttranstarted=2012-08-29T11:46:35.033 XDES=0x555c61950 lockMode=IX schedulerid=15 kpid=8744 status=suspended spid=500 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:35.033 lastbatchcompleted=2012-08-29T11:46:35.033 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340268315 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.44 spid37s executionStack

    2012-08-29 11:46:42.44 spid37s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:42.44 spid37s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:42.44 spid37s inputbuf

    2012-08-29 11:46:42.44 spid37s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:42.44 spid37s process id=processa82b708 taskpriority=0 logused=33108100 waitresource=PAGE: 126:1:3139461 waittime=155 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.44 spid37s executionStack

    2012-08-29 11:46:42.44 spid37s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 11:46:42.44 spid37s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 11:46:42.44 spid37s inputbuf

    2012-08-29 11:46:42.44 spid37s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 11:46:42.44 spid37s resource-list

    2012-08-29 11:46:42.44 spid37s pagelock fileid=1 pageid=2431514 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6517680 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:42.44 spid37s owner-list

    2012-08-29 11:46:42.44 spid37s owner id=processa82b708 mode=U

    2012-08-29 11:46:42.44 spid37s waiter-list

    2012-08-29 11:46:42.44 spid37s waiter id=process5ac5708 mode=IX requestType=wait

    2012-08-29 11:46:42.44 spid37s pagelock fileid=1 pageid=3139461 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock67c0d0880 mode=IX associatedObjectId=72057594042318848

    2012-08-29 11:46:42.44 spid37s owner-list

    2012-08-29 11:46:42.44 spid37s owner id=process5ac5708 mode=IX

    2012-08-29 11:46:42.44 spid37s waiter-list

    2012-08-29 11:46:42.44 spid37s waiter id=processa82b708 mode=U requestType=wait

    2012-08-29 11:46:42.55 spid29s deadlock-list

    2012-08-29 11:46:42.55 spid29s deadlock victim=process4e1d4c8

    2012-08-29 11:46:42.55 spid29s process-list

    2012-08-29 11:46:42.55 spid29s process id=process4e1d4c8 taskpriority=0 logused=692 waitresource=PAGE: 126:1:3994893 waittime=14794 ownerId=30340259260 transactionname=DELETE lasttranstarted=2012-08-29T11:46:27.760 XDES=0x6186de3b0 lockMode=IX schedulerid=6 kpid=13724 status=suspended spid=481 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:27.760 lastbatchcompleted=2012-08-29T11:46:27.757 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340259260 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.55 spid29s executionStack

    2012-08-29 11:46:42.55 spid29s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:42.55 spid29s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:42.55 spid29s inputbuf

    2012-08-29 11:46:42.55 spid29s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:42.55 spid29s process id=processa82b708 taskpriority=0 logused=33112420 waitresource=PAGE: 126:1:3139730 waittime=108 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.55 spid29s executionStack

    2012-08-29 11:46:42.55 spid29s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 11:46:42.55 spid29s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 11:46:42.55 spid29s inputbuf

    2012-08-29 11:46:42.55 spid29s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 11:46:42.55 spid29s resource-list

    2012-08-29 11:46:42.55 spid29s pagelock fileid=1 pageid=3994893 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6971f80 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:42.55 spid29s owner-list

    2012-08-29 11:46:42.55 spid29s owner id=processa82b708 mode=U

    2012-08-29 11:46:42.55 spid29s waiter-list

    2012-08-29 11:46:42.55 spid29s waiter id=process4e1d4c8 mode=IX requestType=wait

    2012-08-29 11:46:42.55 spid29s pagelock fileid=1 pageid=3139730 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock20de94600 mode=IX associatedObjectId=72057594042318848

    2012-08-29 11:46:42.55 spid29s owner-list

    2012-08-29 11:46:42.55 spid29s owner id=process4e1d4c8 mode=IX

    2012-08-29 11:46:42.55 spid29s waiter-list

    2012-08-29 11:46:42.55 spid29s waiter id=processa82b708 mode=U requestType=wait

    2012-08-29 11:46:42.66 spid24s deadlock-list

    2012-08-29 11:46:42.66 spid24s deadlock victim=process5085948

    2012-08-29 11:46:42.66 spid24s process-list

    2012-08-29 11:46:42.66 spid24s process id=process5085948 taskpriority=0 logused=692 waitresource=PAGE: 126:1:3994893 waittime=12722 ownerId=30340261323 transactionname=DELETE lasttranstarted=2012-08-29T11:46:29.930 XDES=0x3b8f5ee80 lockMode=IX schedulerid=10 kpid=312 status=suspended spid=488 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:29.930 lastbatchcompleted=2012-08-29T11:46:29.927 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340261323 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.66 spid24s executionStack

    2012-08-29 11:46:42.66 spid24s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:42.66 spid24s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:42.66 spid24s inputbuf

    2012-08-29 11:46:42.66 spid24s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:42.66 spid24s process id=processa82b708 taskpriority=0 logused=33117820 waitresource=PAGE: 126:1:5219360 waittime=107 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.66 spid24s executionStack

    2012-08-29 11:46:42.66 spid24s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 11:46:42.66 spid24s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 11:46:42.66 spid24s inputbuf

    2012-08-29 11:46:42.66 spid24s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 11:46:42.66 spid24s resource-list

    2012-08-29 11:46:42.66 spid24s pagelock fileid=1 pageid=3994893 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6971f80 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:42.66 spid24s owner-list

    2012-08-29 11:46:42.66 spid24s owner id=processa82b708 mode=U

    2012-08-29 11:46:42.66 spid24s waiter-list

    2012-08-29 11:46:42.66 spid24s waiter id=process5085948 mode=IX requestType=wait

    2012-08-29 11:46:42.66 spid24s pagelock fileid=1 pageid=5219360 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=locka9479980 mode=IX associatedObjectId=72057594042318848

    2012-08-29 11:46:42.66 spid24s owner-list

    2012-08-29 11:46:42.66 spid24s owner id=process5085948 mode=IX

    2012-08-29 11:46:42.66 spid24s waiter-list

    2012-08-29 11:46:42.66 spid24s waiter id=processa82b708 mode=U requestType=wait

    2012-08-29 11:46:42.77 spid28s deadlock-list

    2012-08-29 11:46:42.77 spid28s deadlock victim=processb2ee08

    2012-08-29 11:46:42.77 spid28s process-list

    2012-08-29 11:46:42.77 spid28s process id=processb2ee08 taskpriority=0 logused=692 waitresource=PAGE: 126:1:3994893 waittime=10797 ownerId=30340264301 transactionname=DELETE lasttranstarted=2012-08-29T11:46:31.977 XDES=0x32a4fb950 lockMode=IX schedulerid=3 kpid=6656 status=suspended spid=493 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:31.977 lastbatchcompleted=2012-08-29T11:46:31.977 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340264301 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.77 spid28s executionStack

    2012-08-29 11:46:42.77 spid28s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:42.77 spid28s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:42.77 spid28s inputbuf

    2012-08-29 11:46:42.77 spid28s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:42.77 spid28s process id=processa810508 taskpriority=0 logused=692 waitresource=PAGE: 126:1:3994893 waittime=9795 ownerId=30340265723 transactionname=DELETE lasttranstarted=2012-08-29T11:46:32.967 XDES=0x4b0026e80 lockMode=IX schedulerid=21 kpid=10960 status=suspended spid=496 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:32.967 lastbatchcompleted=2012-08-29T11:46:32.967 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340265723 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.77 spid28s executionStack

    2012-08-29 11:46:42.77 spid28s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:42.77 spid28s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:42.77 spid28s inputbuf

    2012-08-29 11:46:42.77 spid28s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:42.77 spid28s process id=processa82b708 taskpriority=0 logused=33123340 waitresource=PAGE: 126:1:3139909 waittime=107 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.77 spid28s executionStack

    2012-08-29 11:46:42.77 spid28s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 11:46:42.77 spid28s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 11:46:42.77 spid28s inputbuf

    2012-08-29 11:46:42.77 spid28s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 11:46:42.77 spid28s resource-list

    2012-08-29 11:46:42.77 spid28s pagelock fileid=1 pageid=3994893 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6971f80 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:42.77 spid28s owner-list

    2012-08-29 11:46:42.77 spid28s owner id=processa82b708 mode=U

    2012-08-29 11:46:42.77 spid28s waiter-list

    2012-08-29 11:46:42.77 spid28s waiter id=processb2ee08 mode=IX requestType=wait

    2012-08-29 11:46:42.77 spid28s pagelock fileid=1 pageid=3994893 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6971f80 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:42.77 spid28s owner-list

    2012-08-29 11:46:42.77 spid28s waiter-list

    2012-08-29 11:46:42.77 spid28s waiter id=processa810508 mode=IX requestType=wait

    2012-08-29 11:46:42.77 spid28s pagelock fileid=1 pageid=3139909 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e5040300 mode=IX associatedObjectId=72057594042318848

    2012-08-29 11:46:42.77 spid28s owner-list

    2012-08-29 11:46:42.77 spid28s owner id=processa810508 mode=IX

    2012-08-29 11:46:42.77 spid28s waiter-list

    2012-08-29 11:46:42.77 spid28s waiter id=processa82b708 mode=U requestType=wait

    2012-08-29 11:46:42.87 spid21s deadlock-list

    2012-08-29 11:46:42.87 spid21s deadlock victim=processa810508

    2012-08-29 11:46:42.87 spid21s process-list

    2012-08-29 11:46:42.87 spid21s process id=processa810508 taskpriority=0 logused=692 waitresource=PAGE: 126:1:3994893 waittime=9904 ownerId=30340265723 transactionname=DELETE lasttranstarted=2012-08-29T11:46:32.967 XDES=0x4b0026e80 lockMode=IX schedulerid=21 kpid=10960 status=suspended spid=496 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:32.967 lastbatchcompleted=2012-08-29T11:46:32.967 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340265723 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.87 spid21s executionStack

    2012-08-29 11:46:42.87 spid21s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:42.87 spid21s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:42.87 spid21s inputbuf

    2012-08-29 11:46:42.87 spid21s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:42.87 spid21s process id=processa82b708 taskpriority=0 logused=33123340 waitresource=PAGE: 126:1:3139909 waittime=217 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.87 spid21s executionStack

    2012-08-29 11:46:42.88 spid21s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 11:46:42.88 spid21s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 11:46:42.88 spid21s inputbuf

    2012-08-29 11:46:42.88 spid21s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 11:46:42.88 spid21s resource-list

    2012-08-29 11:46:42.88 spid21s pagelock fileid=1 pageid=3994893 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6971f80 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:42.88 spid21s owner-list

    2012-08-29 11:46:42.88 spid21s owner id=processa82b708 mode=U

    2012-08-29 11:46:42.88 spid21s waiter-list

    2012-08-29 11:46:42.88 spid21s waiter id=processa810508 mode=IX requestType=wait

    2012-08-29 11:46:42.88 spid21s pagelock fileid=1 pageid=3139909 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e5040300 mode=IX associatedObjectId=72057594042318848

    2012-08-29 11:46:42.88 spid21s owner-list

    2012-08-29 11:46:42.88 spid21s owner id=processa810508 mode=IX

    2012-08-29 11:46:42.88 spid21s waiter-list

    2012-08-29 11:46:42.88 spid21s waiter id=processa82b708 mode=U requestType=wait

    2012-08-29 11:46:42.98 spid25s deadlock-list

    2012-08-29 11:46:42.98 spid25s deadlock victim=process81b4c8

    2012-08-29 11:46:42.98 spid25s process-list

    2012-08-29 11:46:42.98 spid25s process id=process81b4c8 taskpriority=0 logused=692 waitresource=PAGE: 126:1:2431512 waittime=8513 ownerId=30340267617 transactionname=DELETE lasttranstarted=2012-08-29T11:46:34.480 XDES=0x3b5623950 lockMode=IX schedulerid=1 kpid=20396 status=suspended spid=499 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:34.480 lastbatchcompleted=2012-08-29T11:46:34.480 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340267617 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.98 spid25s executionStack

    2012-08-29 11:46:42.98 spid25s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 11:46:42.98 spid25s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 11:46:42.98 spid25s inputbuf

    2012-08-29 11:46:42.98 spid25s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 11:46:42.98 spid25s process id=processa82b708 taskpriority=0 logused=33140980 waitresource=PAGE: 126:1:5220149 waittime=106 ownerId=30340249178 transactionname=UPDATE lasttranstarted=2012-08-29T11:46:22.220 XDES=0x357a99cd0 lockMode=U schedulerid=22 kpid=14748 status=suspended spid=244 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T11:46:22.210 lastbatchcompleted=2012-08-29T11:46:22.210 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30340249178 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 11:46:42.98 spid25s executionStack

    2012-08-29 11:46:42.98 spid25s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 11:46:42.98 spid25s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 11:46:42.98 spid25s inputbuf

    2012-08-29 11:46:42.98 spid25s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 11:46:42.98 spid25s resource-list

    2012-08-29 11:46:42.98 spid25s pagelock fileid=1 pageid=2431512 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock46ca13d00 mode=U associatedObjectId=72057594052149248

    2012-08-29 11:46:42.98 spid25s owner-list

    2012-08-29 11:46:42.98 spid25s owner id=processa82b708 mode=U

    2012-08-29 11:46:42.98 spid25s waiter-list

    2012-08-29 11:46:42.98 spid25s waiter id=process81b4c8 mode=IX requestType=wait

    2012-08-29 11:46:42.98 spid25s pagelock fileid=1 pageid=5220149 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock20ec79300 mode=IX associatedObjectId=72057594042318848

    2012-08-29 11:46:42.98 spid25s owner-list

    2012-08-29 11:46:42.98 spid25s owner id=process81b4c8 mode=IX

    2012-08-29 11:46:42.98 spid25s waiter-list

    2012-08-29 11:46:42.98 spid25s waiter id=processa82b708 mode=U requestType=wait

    2012-08-29 12:01:55.03 spid118 Setting database option SINGLE_USER to ON for database WNSDBREP.

    2012-08-29 12:02:07.57 spid118 Starting up database 'WNSDBREP'.

    2012-08-29 12:02:07.59 spid118 The database 'WNSDBREP' is marked RESTORING and is in a state that does not allow recovery to be run.

    2012-08-29 12:02:09.31 spid118 Starting up database 'WNSDBREP'.

    2012-08-29 12:02:09.41 spid118 Recovery is writing a checkpoint in database 'WNSDBREP' (65). This is an informational message only. No user action is required.

    2012-08-29 12:02:10.08 spid118 CHECKDB for database 'WNSDBREP' finished without errors on 2011-12-24 06:05:24.553 (local time). This is an informational message only; no user action is required.

    2012-08-29 12:02:10.09 Backup Restore is complete on database 'WNSDBREP'. The database is now available.

    2012-08-29 12:46:34.76 spid18s deadlock-list

    2012-08-29 12:46:34.76 spid18s deadlock victim=processa810508

    2012-08-29 12:46:34.76 spid18s process-list

    2012-08-29 12:46:34.76 spid18s process id=processa810508 taskpriority=0 logused=692 waitresource=PAGE: 126:1:13610500 waittime=5785 ownerId=30347084588 transactionname=DELETE lasttranstarted=2012-08-29T12:46:28.980 XDES=0x5f16ef950 lockMode=IX schedulerid=21 kpid=10960 status=suspended spid=400 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T12:46:28.980 lastbatchcompleted=2012-08-29T12:46:28.980 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30347084588 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 12:46:34.76 spid18s executionStack

    2012-08-29 12:46:34.76 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MARKARCHIVEDMAILINDAPOOL line=14 stmtstart=468 stmtend=582 sqlhandle=0x03007e0027427f676df9af0090a000000100000000000000

    2012-08-29 12:46:34.76 spid18s DELETE FROM EXCHANGEPAMDAPOOL

    WHERE POOLID = @POOLID

    2012-08-29 12:46:34.76 spid18s inputbuf

    2012-08-29 12:46:34.76 spid18s Proc [Database Id = 126 Object Id = 1736393255]

    2012-08-29 12:46:34.76 spid18s process id=processa84f048 taskpriority=0 logused=33104260 waitresource=PAGE: 126:1:3153543 waittime=2427 ownerId=30347084281 transactionname=UPDATE lasttranstarted=2012-08-29T12:46:28.860 XDES=0x51e184b00 lockMode=U schedulerid=24 kpid=19660 status=suspended spid=394 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T12:46:28.853 lastbatchcompleted=2012-08-29T12:46:28.853 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30347084281 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 12:46:34.76 spid18s executionStack

    2012-08-29 12:46:34.76 spid18s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 12:46:34.76 spid18s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 12:46:34.76 spid18s inputbuf

    2012-08-29 12:46:34.76 spid18s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 12:46:34.76 spid18s resource-list

    2012-08-29 12:46:34.76 spid18s pagelock fileid=1 pageid=13610500 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e4235280 mode=U associatedObjectId=72057594052149248

    2012-08-29 12:46:34.76 spid18s owner-list

    2012-08-29 12:46:34.76 spid18s owner id=processa84f048 mode=U

    2012-08-29 12:46:34.76 spid18s waiter-list

    2012-08-29 12:46:34.76 spid18s waiter id=processa810508 mode=IX requestType=wait

    2012-08-29 12:46:34.76 spid18s pagelock fileid=1 pageid=3153543 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6628700 mode=IX associatedObjectId=72057594042318848

    2012-08-29 12:46:34.76 spid18s owner-list

    2012-08-29 12:46:34.76 spid18s owner id=processa810508 mode=IX

    2012-08-29 12:46:34.76 spid18s waiter-list

    2012-08-29 12:46:34.76 spid18s waiter id=processa84f048 mode=U requestType=wait

    2012-08-29 12:46:52.30 spid17s deadlock-list

    2012-08-29 12:46:52.30 spid17s deadlock victim=process81b048

    2012-08-29 12:46:52.30 spid17s process-list

    2012-08-29 12:46:52.30 spid17s process id=process81b048 taskpriority=0 logused=1284 waitresource=PAGE: 126:1:13613549 waittime=21068 ownerId=30347088820 transactionname=INSERT lasttranstarted=2012-08-29T12:46:31.233 XDES=0x85186b3c0 lockMode=IX schedulerid=1 kpid=16572 status=suspended spid=64 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T12:46:31.233 lastbatchcompleted=2012-08-29T12:46:31.233 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30347088820 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 12:46:52.30 spid17s executionStack

    2012-08-29 12:46:52.30 spid17s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_ADDMAILTODAPOOL line=22 stmtstart=916 stmtend=1572 sqlhandle=0x03007e00ee1d8b666df9af0090a000000100000000000000

    2012-08-29 12:46:52.30 spid17s INSERT INTO EXCHANGEPAMDAPOOL (MBXID, URL, ACTION, OTHERPARAMETERS, ARCHIVEMETHOD, BODYASCONTENT, USEHTMLBODY,

    CURRENTUSER, JOBID, MSGSTATUS, JOBSTART, RETCATID)

    VALUES (@MBXID, @URL, @ACTION, @OTHERPARAMETERS, @ARCHIVEMETHOD, @BODYASCONTENT, @USEHTMLBODY, @CURRENTUSER, @JOBID, @MSGSTATUS, @JOBSTART, @RETCATID)

    2012-08-29 12:46:52.30 spid17s inputbuf

    2012-08-29 12:46:52.30 spid17s Proc [Database Id = 126 Object Id = 1720393198]

    2012-08-29 12:46:52.30 spid17s process id=processa84f048 taskpriority=0 logused=243852580 waitresource=PAGE: 126:1:2812446 waittime=3451 ownerId=30347084281 transactionname=UPDATE lasttranstarted=2012-08-29T12:46:28.860 XDES=0x51e184b00 lockMode=U schedulerid=24 kpid=19660 status=suspended spid=394 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2012-08-29T12:46:28.853 lastbatchcompleted=2012-08-29T12:46:28.853 clientapp=.Net SqlClient Data Provider hostname=WIMVMARCHJOR1 hostpid=1440 loginname=MetalogixPAM isolationlevel=read committed (2) xactid=30347084281 currentdb=126 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056

    2012-08-29 12:46:52.30 spid17s executionStack

    2012-08-29 12:46:52.30 spid17s frame procname=JOurnalExchangeDB.metalogixpam.SP_EXPAM_MANAGEDAPOOL line=16 stmtstart=580 stmtend=808 sqlhandle=0x03007e000ea50f05e6f8af0090a000000100000000000000

    2012-08-29 12:46:52.30 spid17s UPDATE EXCHANGEPAMDAPOOL SET MSGSTATUS = @MSGSTATUS WHERE JOBID = @JOBID AND (MSGSTATUS <> 3 AND MSGSTATUS <> 4)

    2012-08-29 12:46:52.30 spid17s inputbuf

    2012-08-29 12:46:52.30 spid17s Proc [Database Id = 126 Object Id = 84911374]

    2012-08-29 12:46:52.30 spid17s resource-list

    2012-08-29 12:46:52.30 spid17s pagelock fileid=1 pageid=13613549 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock2e6f0ef00 mode=U associatedObjectId=72057594052149248

    2012-08-29 12:46:52.30 spid17s owner-list

    2012-08-29 12:46:52.30 spid17s owner id=processa84f048 mode=U

    2012-08-29 12:46:52.30 spid17s waiter-list

    2012-08-29 12:46:52.30 spid17s waiter id=process81b048 mode=IX requestType=wait

    2012-08-29 12:46:52.30 spid17s pagelock fileid=1 pageid=2812446 dbid=126 objectname=JOurnalExchangeDB.metalogixpam.EXCHANGEPAMDAPOOL id=lock7634f4c00 mode=IX associatedObjectId=72057594042318848

    2012-08-29 12:46:52.30 spid17s owner-list

    2012-08-29 12:46:52.30 spid17s owner id=process81b048 mode=IX

    2012-08-29 12:46:52.30 spid17s waiter-list

    2012-08-29 12:46:52.30 spid17s waiter id=processa84f048 mode=U requestType=wait