Tag Info

New answers tagged

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 ...


1

The conflict boils down to network_activity being an Indexed View which needs to be maintained (internally) across the DML statements. That is most likely why SP1 is wanting a lock on the IX_follow-member_id_includes index as it is probably used by the View (it looks to be a covering index for the View). Two possible options: Consider dropping the ...


5

Based on what I see in SQL Sentry Plan Explorer PRO*, looks like two different jobs are fighting over who is going to get to delete some rows (click to enlarge): Maybe there is some overlap because Microsoft does some not-so-optimal things in msdb.dbo.sp_syscollector_purge_collection_logs, for instance letting each invocation of the procedure grab ...


0

Rather than re-write an already great blog post, please see this PFE post about logging deadlocks: Deadlock Logging Once you have the XML, graph, or TF1222 output you should be able to see all of the players involved and what happened. From there it would be possible to take corrective action, which will depends on what is all involved. If you would like ...



Top 50 recent answers are included