tobe_ha (9/4/2015)
ScottPletcher (9/4/2015)
Does the log table have an identity column? Did you try removing that column and see if the table is still locked? Typically multiple tasks should be able to write to a table as part of a transaction.Yes it had. I replaced it by usage of a sequence now - but the behavior did not change.
Hmm, you shouldn't really need a sequence either. Anything that serializes the requests might (not necessarily will) cause a disruption.
Cluster it by datetime written. That should allow multiple tasks to write to the table at the same time. SQL will resolve the duplicates for you. Later, if you need to, you can add your own "uniquifier".
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.