How to avoid dead locks in Share point databases?

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  February 18, 2010 at 11:05 am

  #211295

  Hi,

  We have SQL Server 2005 EE x64 with SP3 with MOSS 2007 SP1 databases. Whenever the Share point admin runs the Crawing, we are getting Deadlocks in SQL Server instance. I went throught the dead lock graph and Microsoft says that we should NOT change any Indexes for Share point database's tables and if we do anything, Microsoft won't support. In that case how can we avoid dead locks in Share point databases? please advice how you guys are handing these dead locks? Can we ignore these dead locks?

  2010-02-18 01:43:48.76 spid15s deadlock victim=processf24718

  2010-02-18 01:43:48.76 spid15s process-list

  2010-02-18 01:43:48.76 spid15s process id=processbae868 taskpriority=0 logused=9253800 waitresource=PAGE: 20:1:47728 waittime=3250 ownerId=43717597 transactionname=user_transaction lasttranstarted=2010-02-18T01:43:44.170 XDES=0x323d41ab0 lockMode=S schedulerid=1 kpid=4456 status=suspended spid=73 sbid=0 ecid=0 priority=0 transcount=1 lastbatchstarted=2010-02-18T01:43:44.170 lastbatchcompleted=2010-02-18T01:43:44.170 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=5284 loginname=abc\mosssearch isolationlevel=read committed (2) xactid=43717597 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

  2010-02-18 01:43:48.77 spid15s executionStack

  2010-02-18 01:43:48.77 spid15s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_GetNextCrawlBatch line=173 stmtstart=13866 stmtend=17396 sqlhandle=0x03001400c610834ac84c3301ab9c00000100000000000000

  2010-02-18 01:43:48.77 spid15s SELECT CrawlID,

  2010-02-18 01:43:48.77 spid15s SourceDocID,

  2010-02-18 01:43:48.77 spid15s DocID,

  2010-02-18 01:43:48.77 spid15s NULL,

  2010-02-18 01:43:48.77 spid15s NULL,

  2010-02-18 01:43:48.77 spid15s NULL,

  2010-02-18 01:43:48.77 spid15s 0,

  2010-02-18 01:43:48.77 spid15s StartAddressID,

  2010-02-18 01:43:48.77 spid15s HostDepth,

  2010-02-18 01:43:48.77 spid15s EnumerationDepth,

  2010-02-18 01:43:48.77 spid15s TransactionFlags,

  2010-02-18 01:43:48.77 spid15s 0,

  2010-02-18 01:43:48.77 spid15s 0,

  2010-02-18 01:43:48.77 spid15s 0,

  2010-02-18 01:43:48.77 spid15s 1,

  2010-02-18 01:43:48.77 spid15s CONVERT(bigint, 0),

  2010-02-18 01:43:48.77 spid15s 0,

  2010-02-18 01:43:48.77 spid15s CONVERT(bigint, 0),

  2010-02-18 01:43:48.77 spid15s CONVERT(bigint, 0),

  2010-02-18 01:43:48.77 spid15s 0,

  2010-02-18 01:43:48.77 spid15s 0,

  2010-02-18 01:43:48.77 spid15s TransactionType,

  2010-02-18 01:43:48.77 spid15s 0,

  2010-02-18 01:43:48.77 spid15s ItemType,

  2010-02-18 01:43:48.77 spid15s FolderHighPriority,

  2010-02-18 01:43:48.77 spid15s ItemHighPriority,

  2010-02-18 01:43:48.77 spid15s SeqID,

  2010-02-18 01:43:48.77 spid15s NULL,

  2010-02-18 01:43:48.77 spid15s ChangeLogBatchID,

  2010-02-18 01:43:48.77 spid15s SCOPE,

  2010-02-18 01:43:48.77 spid15s CONVERT(bigint, 0),

  2010-02-18 01:43:48.77 spid15s 0

  2010-02-18 01:43:48.77 spid15s FROM MSSCrawlQueue

  2010-02-18 01:43:48.77 spid15s WHERE CrawlID = @CrawlID AND BatchID = @BatchID AND (ItemType = @ITEMTYPE_ANCHORNEWLINK or ItemType = @ITEMTYPE_ANCHORCOMMITTED)

  2010-02-18 01:43:48.77 spid15s UNION

  2010-02-18 01:43:48.77 spid15s SELECT A.CrawlID,

  2010-02-18 01:43:48.77 spid15s A.SourceDocID,

  2010-02-18 01:43:48.77 spid15s A.DocID,

  2010-02-18 01:43:48.77 spid15s B.DisplayURL,

  2010-02-18 01:43:48.77 spid15s B.AccessURL,

  2010-02-18 01:43:48.77 spid15s B.CompactURL,

  2010-02-18 01:43:48.77 spid15s B.EndPathFlag,

  2010-02-18 01:43:48.77 spid15s A.StartAddressID,

  2010-02-18 01:43:48.77 spid15s A.HostDepth,

  2010-02-18 01:43:48.77 spid15s A.EnumerationDep

  2010-02-18 01:43:48.77 spid15s inputbuf

  2010-02-18 01:43:48.77 spid15s Proc [Database Id = 20 Object Id = 1250103494]

  2010-02-18 01:43:48.77 spid15s process id=processf24718 taskpriority=0 logused=252 waitresource=PAGE: 20:1:499 waittime=4406 ownerId=43717621 transactionname=user_transaction lasttranstarted=2010-02-18T01:43:44.353 XDES=0x31badccf0 lockMode=IX schedulerid=2 kpid=164 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-02-18T01:43:44.353 lastbatchcompleted=2010-02-18T01:43:44.353 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=5284 loginname=abc\mosssearch isolationlevel=read committed (2) xactid=43717621 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

  2010-02-18 01:43:48.77 spid15s executionStack

  2010-02-18 01:43:48.77 spid15s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=159 stmtstart=13102 stmtend=13208 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000

  2010-02-18 01:43:48.77 spid15s DELETE FROM MSSCrawlQueue WHERE SeqID = @SeqID

  2010-02-18 01:43:48.77 spid15s inputbuf

  2010-02-18 01:43:48.77 spid15s Proc [Database Id = 20 Object Id = 1138103095]

  2010-02-18 01:43:48.77 spid15s resource-list

  2010-02-18 01:43:48.77 spid15s pagelock fileid=1 pageid=499 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue id=lock9f9f1c00 mode=UIX associatedObjectId=72057594078429184

  2010-02-18 01:43:48.77 spid15s owner-list

  2010-02-18 01:43:48.77 spid15s owner id=processbae868 mode=UIX

  2010-02-18 01:43:48.77 spid15s waiter-list

  2010-02-18 01:43:48.77 spid15s waiter id=processf24718 mode=IX requestType=wait

  2010-02-18 01:43:48.77 spid15s pagelock fileid=1 pageid=47728 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue id=lock9fcd4600 mode=IX associatedObjectId=72057594078298112

  2010-02-18 01:43:48.77 spid15s owner-list

  2010-02-18 01:43:48.77 spid15s owner id=processf24718 mode=IX

  2010-02-18 01:43:48.77 spid15s waiter-list

  2010-02-18 01:43:48.77 spid15s waiter id=processbae868 mode=S requestType=convert

  2010-02-18 01:44:04.46 spid19s deadlock-list

  2010-02-18 01:44:04.46 spid19s deadlock victim=processbae868

  2010-02-18 01:44:04.46 spid19s process-list

  2010-02-18 01:44:04.46 spid19s process id=processbae868 taskpriority=0 logused=1288 waitresource=PAGE: 20:1:49131 waittime=2218 ownerId=43728678 transactionname=user_transaction lasttranstarted=2010-02-18T01:44:02.007 XDES=0x323d41ab0 lockMode=IX schedulerid=1 kpid=4456 status=suspended spid=73 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-02-18T01:44:02.007 lastbatchcompleted=2010-02-18T01:44:02.007 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=5284 loginname=abc\mosssearch isolationlevel=read committed (2) xactid=43728678 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

  2010-02-18 01:44:04.46 spid19s executionStack

  2010-02-18 01:44:04.46 spid19s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=249 stmtstart=19366 stmtend=21120 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000

  2010-02-18 01:44:04.46 spid19s INSERT INTO MSSCrawlQueue (

  2010-02-18 01:44:04.46 spid19s CrawlID,

  2010-02-18 01:44:04.46 spid19s StartAddressID,

  2010-02-18 01:44:04.46 spid19s DocID,

  2010-02-18 01:44:04.46 spid19s TransactionType,

  2010-02-18 01:44:04.46 spid19s Scope,

  2010-02-18 01:44:04.46 spid19s TransactionFlags,

  2010-02-18 01:44:04.46 spid19s HostDepth,

  2010-02-18 01:44:04.46 spid19s EnumerationDepth,

  2010-02-18 01:44:04.46 spid19s SourceDocID,

  2010-02-18 01:44:04.46 spid19s ChangeLogBatchID,

  2010-02-18 01:44:04.46 spid19s ItemType,

  2010-02-18 01:44:04.46 spid19s FolderHighPriority,

  2010-02-18 01:44:04.46 spid19s ItemHighPriority,

  2010-02-18 01:44:04.46 spid19s ProjectID,

  2010-02-18 01:44:04.46 spid19s DeleteReason,

  2010-02-18 01:44:04.46 spid19s ErrorID)

  2010-02-18 01:44:04.46 spid19s VALUES(

  2010-02-18 01:44:04.46 spid19s @CrawlID,

  2010-02-18 01:44:04.46 spid19s @StartAddressID,

  2010-02-18 01:44:04.46 spid19s @DocID,

  2010-02-18 01:44:04.46 spid19s @GTHR_CA_DELETE,

  2010-02-18 01:44:04.46 spid19s @SCOPE_DEEP,

  2010-02-18 01:44:04.46 spid19s @TransactionFlags,

  2010-02-18 01:44:04.46 spid19s 0,

  2010-02-18 01:44:04.46 spid19s 0,

  2010-02-18 01:44:04.46 spid19s 0,

  2010-02-18 01:44:04.46 spid19s @ChangeLogBatchID,

  2010-02-18 01:44:04.46 spid19s @ItemType,

  2010-02-18 01:44:04.46 spid19s 0,

  2010-02-18 01:44:04.46 spid19s 0,

  2010-02-18 01:44:04.46 spid19s @ProjectID,

  2010-02-18 01:44:04.46 spid19s @DELETE_ERROR,

  2010-02-18 01:44:04.46 spid19s @ErrorID)

  2010-02-18 01:44:04.46 spid19s inputbuf

  2010-02-18 01:44:04.46 spid19s Proc [Database Id = 20 Object Id = 1138103095]

  2010-02-18 01:44:04.46 spid19s process id=processfa85c8 taskpriority=0 logused=4209176 waitresource=PAGE: 20:1:47153 waittime=2046 ownerId=43728616 transactionname=user_transaction lasttranstarted=2010-02-18T01:44:01.643 XDES=0x205e52370 lockMode=S schedulerid=8 kpid=5356 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=1 lastbatchstarted=2010-02-18T01:44:01.643 lastbatchcompleted=2010-02-18T01:44:01.643 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=5284 loginname=abc\mosssearch isolationlevel=read committed (2) xactid=43728616 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

  2010-02-18 01:44:04.46 spid19s executionStack

  2010-02-18 01:44:04.46 spid19s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_GetNextCrawlBatch line=173 stmtstart=13866 stmtend=17396 sqlhandle=0x03001400c610834ac84c3301ab9c00000100000000000000

  2010-02-18 01:44:04.46 spid19s SELECT CrawlID,

  2010-02-18 01:44:04.46 spid19s SourceDocID,

  2010-02-18 01:44:04.46 spid19s DocID,

  2010-02-18 01:44:04.46 spid19s NULL,

  2010-02-18 01:44:04.46 spid19s NULL,

  2010-02-18 01:44:04.46 spid19s NULL,

  2010-02-18 01:44:04.46 spid19s 0,

  2010-02-18 01:44:04.46 spid19s StartAddressID,

  2010-02-18 01:44:04.46 spid19s HostDepth,

  2010-02-18 01:44:04.46 spid19s EnumerationDepth,

  2010-02-18 01:44:04.46 spid19s TransactionFlags,

  2010-02-18 01:44:04.46 spid19s 0,

  2010-02-18 01:44:04.46 spid19s 0,

  2010-02-18 01:44:04.46 spid19s 0,

  2010-02-18 01:44:04.46 spid19s 1,

  2010-02-18 01:44:04.46 spid19s CONVERT(bigint, 0),

  2010-02-18 01:44:04.46 spid19s 0,

  2010-02-18 01:44:04.46 spid19s CONVERT(bigint, 0),

  2010-02-18 01:44:04.46 spid19s CONVERT(bigint, 0),

  2010-02-18 01:44:04.46 spid19s 0,

  2010-02-18 01:44:04.46 spid19s 0,

  2010-02-18 01:44:04.46 spid19s TransactionType,

  2010-02-18 01:44:04.46 spid19s 0,

  2010-02-18 01:44:04.46 spid19s ItemType,

  2010-02-18 01:44:04.46 spid19s FolderHighPriority,

  2010-02-18 01:44:04.46 spid19s ItemHighPriority,

  2010-02-18 01:44:04.46 spid19s SeqID,

  2010-02-18 01:44:04.46 spid19s NULL,

  2010-02-18 01:44:04.46 spid19s ChangeLogBatchID,

  2010-02-18 01:44:04.46 spid19s SCOPE,

  2010-02-18 01:44:04.46 spid19s CONVERT(bigint, 0),

  2010-02-18 01:44:04.46 spid19s 0

  2010-02-18 01:44:04.46 spid19s FROM MSSCrawlQueue

  2010-02-18 01:44:04.46 spid19s WHERE CrawlID = @CrawlID AND BatchID = @BatchID AND (ItemType = @ITEMTYPE_ANCHORNEWLINK or ItemType = @ITEMTYPE_ANCHORCOMMITTED)

  2010-02-18 01:44:04.46 spid19s UNION

  2010-02-18 01:44:04.46 spid19s SELECT A.CrawlID,

  2010-02-18 01:44:04.46 spid19s A.SourceDocID,

  2010-02-18 01:44:04.46 spid19s A.DocID,

  2010-02-18 01:44:04.46 spid19s B.DisplayURL,

  2010-02-18 01:44:04.46 spid19s B.AccessURL,

  2010-02-18 01:44:04.46 spid19s B.CompactURL,

  2010-02-18 01:44:04.46 spid19s B.EndPathFlag,

  2010-02-18 01:44:04.46 spid19s A.StartAddressID,

  2010-02-18 01:44:04.46 spid19s A.HostDepth,

  2010-02-18 01:44:04.46 spid19s A.EnumerationDep

  2010-02-18 01:44:04.46 spid19s inputbuf

  2010-02-18 01:44:04.46 spid19s Proc [Database Id = 20 Object Id = 1250103494]

  2010-02-18 01:44:04.46 spid19s resource-list

  2010-02-18 01:44:04.46 spid19s pagelock fileid=1 pageid=47153 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue id=locka58bc300 mode=IX associatedObjectId=72057594078298112

  2010-02-18 01:44:04.46 spid19s owner-list

  2010-02-18 01:44:04.46 spid19s owner id=processbae868 mode=IX

  2010-02-18 01:44:04.46 spid19s waiter-list

  2010-02-18 01:44:04.46 spid19s waiter id=processfa85c8 mode=S requestType=wait

  2010-02-18 01:44:04.46 spid19s pagelock fileid=1 pageid=49131 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue id=locka7732b80 mode=UIX associatedObjectId=72057594078494720

  2010-02-18 01:44:04.46 spid19s owner-list

  2010-02-18 01:44:04.46 spid19s owner id=processfa85c8 mode=UIX

  2010-02-18 01:44:04.46 spid19s waiter-list

  2010-02-18 01:44:04.46 spid19s waiter id=processbae868 mode=IX requestType=wait

  2010-02-18 01:44:09.60 spid9s deadlock-list

  2010-02-18 01:44:09.60 spid9s deadlock victim=processbae868

  2010-02-18 01:44:09.60 spid9s process-list

  2010-02-18 01:44:09.60 spid9s process id=processbae868 taskpriority=0 logused=1160 waitresource=PAGE: 20:1:586 waittime=5000 ownerId=43729801 transactionname=user_transaction lasttranstarted=2010-02-18T01:44:04.593 XDES=0x323d41ab0 lockMode=IX schedulerid=1 kpid=4456 status=suspended spid=73 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-02-18T01:44:04.593 lastbatchcompleted=2010-02-18T01:44:04.593 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=5284 loginname=abc\mosssearch isolationlevel=read committed (2) xactid=43729801 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

  2010-02-18 01:44:09.60 spid9s executionStack

  2010-02-18 01:44:09.60 spid9s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_ProcessCommitted line=249 stmtstart=19366 stmtend=21120 sqlhandle=0x030014003713d643a44c3301ab9c00000100000000000000

  2010-02-18 01:44:09.60 spid9s INSERT INTO MSSCrawlQueue (

  2010-02-18 01:44:09.60 spid9s CrawlID,

  2010-02-18 01:44:09.60 spid9s StartAddressID,

  2010-02-18 01:44:09.60 spid9s DocID,

  2010-02-18 01:44:09.60 spid9s TransactionType,

  2010-02-18 01:44:09.60 spid9s Scope,

  2010-02-18 01:44:09.60 spid9s TransactionFlags,

  2010-02-18 01:44:09.60 spid9s HostDepth,

  2010-02-18 01:44:09.60 spid9s EnumerationDepth,

  2010-02-18 01:44:09.60 spid9s SourceDocID,

  2010-02-18 01:44:09.60 spid9s ChangeLogBatchID,

  2010-02-18 01:44:09.60 spid9s ItemType,

  2010-02-18 01:44:09.60 spid9s FolderHighPriority,

  2010-02-18 01:44:09.60 spid9s ItemHighPriority,

  2010-02-18 01:44:09.60 spid9s ProjectID,

  2010-02-18 01:44:09.60 spid9s DeleteReason,

  2010-02-18 01:44:09.60 spid9s ErrorID)

  2010-02-18 01:44:09.60 spid9s VALUES(

  2010-02-18 01:44:09.60 spid9s @CrawlID,

  2010-02-18 01:44:09.60 spid9s @StartAddressID,

  2010-02-18 01:44:09.60 spid9s @DocID,

  2010-02-18 01:44:09.60 spid9s @GTHR_CA_DELETE,

  2010-02-18 01:44:09.60 spid9s @SCOPE_DEEP,

  2010-02-18 01:44:09.60 spid9s @TransactionFlags,

  2010-02-18 01:44:09.60 spid9s 0,

  2010-02-18 01:44:09.60 spid9s 0,

  2010-02-18 01:44:09.60 spid9s 0,

  2010-02-18 01:44:09.60 spid9s @ChangeLogBatchID,

  2010-02-18 01:44:09.60 spid9s @ItemType,

  2010-02-18 01:44:09.60 spid9s 0,

  2010-02-18 01:44:09.60 spid9s 0,

  2010-02-18 01:44:09.60 spid9s @ProjectID,

  2010-02-18 01:44:09.60 spid9s @DELETE_ERROR,

  2010-02-18 01:44:09.60 spid9s @ErrorID)

  2010-02-18 01:44:09.60 spid9s inputbuf

  2010-02-18 01:44:09.60 spid9s Proc [Database Id = 20 Object Id = 1138103095]

  2010-02-18 01:44:09.60 spid9s process id=processfa85c8 taskpriority=0 logused=4209176 waitresource=PAGE: 20:1:49147 waittime=4281 ownerId=43728616 transactionname=user_transaction lasttranstarted=2010-02-18T01:44:01.643 XDES=0x205e52370 lockMode=S schedulerid=8 kpid=5356 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=1 lastbatchstarted=2010-02-18T01:44:01.643 lastbatchcompleted=2010-02-18T01:44:01.643 clientapp=Windows SharePoint Services hostname=MOSS1 hostpid=5284 loginname=abc\mosssearch isolationlevel=read committed (2) xactid=43728616 currentdb=20 lockTimeout=4294967295 clientoption1=673316896 clientoption2=128056

  2010-02-18 01:44:09.60 spid9s executionStack

  2010-02-18 01:44:09.60 spid9s frame procname=SharedServices1_Search_DB.dbo.proc_MSS_GetNextCrawlBatch line=173 stmtstart=13866 stmtend=17396 sqlhandle=0x03001400c610834ac84c3301ab9c00000100000000000000

  2010-02-18 01:44:09.60 spid9s SELECT CrawlID,

  2010-02-18 01:44:09.60 spid9s SourceDocID,

  2010-02-18 01:44:09.60 spid9s DocID,

  2010-02-18 01:44:09.60 spid9s NULL,

  2010-02-18 01:44:09.60 spid9s NULL,

  2010-02-18 01:44:09.60 spid9s NULL,

  2010-02-18 01:44:09.60 spid9s 0,

  2010-02-18 01:44:09.60 spid9s StartAddressID,

  2010-02-18 01:44:09.60 spid9s HostDepth,

  2010-02-18 01:44:09.60 spid9s EnumerationDepth,

  2010-02-18 01:44:09.60 spid9s TransactionFlags,

  2010-02-18 01:44:09.60 spid9s 0,

  2010-02-18 01:44:09.60 spid9s 0,

  2010-02-18 01:44:09.60 spid9s 0,

  2010-02-18 01:44:09.60 spid9s 1,

  2010-02-18 01:44:09.60 spid9s CONVERT(bigint, 0),

  2010-02-18 01:44:09.60 spid9s 0,

  2010-02-18 01:44:09.60 spid9s CONVERT(bigint, 0),

  2010-02-18 01:44:09.60 spid9s CONVERT(bigint, 0),

  2010-02-18 01:44:09.60 spid9s 0,

  2010-02-18 01:44:09.60 spid9s 0,

  2010-02-18 01:44:09.60 spid9s TransactionType,

  2010-02-18 01:44:09.60 spid9s 0,

  2010-02-18 01:44:09.60 spid9s ItemType,

  2010-02-18 01:44:09.60 spid9s FolderHighPriority,

  2010-02-18 01:44:09.60 spid9s ItemHighPriority,

  2010-02-18 01:44:09.60 spid9s SeqID,

  2010-02-18 01:44:09.60 spid9s NULL,

  2010-02-18 01:44:09.60 spid9s ChangeLogBatchID,

  2010-02-18 01:44:09.60 spid9s SCOPE,

  2010-02-18 01:44:09.60 spid9s CONVERT(bigint, 0),

  2010-02-18 01:44:09.60 spid9s 0

  2010-02-18 01:44:09.60 spid9s FROM MSSCrawlQueue

  2010-02-18 01:44:09.60 spid9s WHERE CrawlID = @CrawlID AND BatchID = @BatchID AND (ItemType = @ITEMTYPE_ANCHORNEWLINK or ItemType = @ITEMTYPE_ANCHORCOMMITTED)

  2010-02-18 01:44:09.60 spid9s UNION

  2010-02-18 01:44:09.60 spid9s SELECT A.CrawlID,

  2010-02-18 01:44:09.60 spid9s A.SourceDocID,

  2010-02-18 01:44:09.60 spid9s A.DocID,

  2010-02-18 01:44:09.60 spid9s B.DisplayURL,

  2010-02-18 01:44:09.60 spid9s B.AccessURL,

  2010-02-18 01:44:09.60 spid9s B.CompactURL,

  2010-02-18 01:44:09.60 spid9s B.EndPathFlag,

  2010-02-18 01:44:09.60 spid9s A.StartAddressID,

  2010-02-18 01:44:09.60 spid9s A.HostDepth,

  2010-02-18 01:44:09.60 spid9s A.EnumerationDep

  2010-02-18 01:44:09.60 spid9s inputbuf

  2010-02-18 01:44:09.60 spid9s Proc [Database Id = 20 Object Id = 1250103494]

  2010-02-18 01:44:09.60 spid9s resource-list

  2010-02-18 01:44:09.60 spid9s pagelock fileid=1 pageid=586 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue id=lock9fc65780 mode=UIX associatedObjectId=72057594078429184

  2010-02-18 01:44:09.60 spid9s owner-list

  2010-02-18 01:44:09.60 spid9s owner id=processfa85c8 mode=UIX

  2010-02-18 01:44:09.60 spid9s waiter-list

  2010-02-18 01:44:09.60 spid9s waiter id=processbae868 mode=IX requestType=wait

  2010-02-18 01:44:09.60 spid9s pagelock fileid=1 pageid=49147 dbid=20 objectname=SharedServices1_Search_DB.dbo.MSSCrawlQueue id=lockac0ade80 mode=IX associatedObjectId=72057594078298112

  2010-02-18 01:44:09.60 spid9s owner-list

  2010-02-18 01:44:09.60 spid9s owner id=processbae868 mode=IX

  2010-02-18 01:44:09.60 spid9s waiter-list

  2010-02-18 01:44:09.60 spid9s waiter id=processfa85c8 mode=S requestType=convert