Thank you for your responses - some good suggestions there. We'll test these out and come back to you.

We had tried clustered indexes on ID previously, but they were not...

• This reply was modified 3 years, 4 months ago by  zoggling.

Yes we did that - the deadlocks were occurring between two SPIDs running the delete statement on the temporal table. The locked resource was the temporal table itself, with "IX"...

We attempted delaying each individual SPID by a random number of whole seconds, between 0 and 9. Even this didn't resolve the issue, with deadlocks continuing to occur as before.

Solution was found here:

https://dba.stackexchange.com/questions/63760/sql-server-audit-specification-filter-dml-by-all-but-one-user

Great, thanks!

SwePeso's solution at the following link has been the best help for this.

https://www.sqlteam.com/forums/topic.asp?TOPIC_ID=145825

We created both of those keys (as they were not present), but no cigar sadly. Been Googling for most of the day!!

Thank you for your reply. Unfortunately I have been unable to locate the keys you reference (or any equivalents), throughout the whole registry?

Sue_H - the flags were definitely missing, we scripted the jobs out to check, and also stopped receiving job history information monitoring-side since the job steps were no longer logging...

Thank you all for your replies, apologies but it does appear that some of our obfuscation has resulted in the above script not accurately reproducing the same issue. In addition,...

Hi Sue, thanks very much for your advice!