Tag Info

New answers tagged

4

So what happens if I use it in all my update queries? Like all hints, UPDLOCK should only be used where there is a clear benefit. How will it affect me negatively? It depends on the query and the execution plan. Assuming you are only proposing to add UPDLOCK to the target table, there may be no negative effects at all in very simple cases. A ...


1

as this is standard SharePoint maintenance the OP is unlikely to be responsible for the code or be able to interfere in it. What they could influence, is the time it is run at. dbo.proc_MSS_DefragGathererIndexes should only really be run manually and after your first crawl but not generally otherwise. Can you confirm this proc has not been automated as ...


2

Following information was found for victim process from the deadlock graph Isolationlevel="read uncommitted (1)" for process that was killed as part of deadlock. lasttranstarted="2014-07-25T00:00:41.230" lockMode="X" procname="Search_Service_Application_CrawlStoreDB_3a7fefdbc44a48ef902a65ffb71c7d3a.dbo.proc_MSS_GetNextCrawlBatch" Problematic statement ...


6

Knowing this, why does sql server need to issue U locks (when using RCSI)? It seems to me that sql server could simply read the rows, and request a X lock directly if an update must be performed. Unlike SI, RCSI does not detect update conflicts. As documented in Books Online, modifying data under RCSI reads currently-committed data, not a possibly ...



Top 50 recent answers are included