Tag Info

New answers tagged

5

It is fairly well documented that UDFs force an overall serial plan. I'm not certain it is all that well documented :) A scalar T-SQL function indeed prevents parallelism anywhere in the plan. A scalar CLR function can be executed in parallel, so long as it does not access the database. A multi-statement table-valued T-SQL function forces a serial ...


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