Hi All,
Did anyone get to the bottom of this?
I have had extensive support from our support provider but we are still not any closer to resolving them.
We are getting these almost daily and we can't point to what may have changed.
We have changed times for all data extractor runs.
Support provider has gone into the logs and can see the two user ID's that are causing the deadlock but they dont correlate with any info that could tell us which user this is. (We know the one reporting the issue).
The three attendence users are all getting these deadlock errors, even when working in different tables (year groups).
We just ran an update on our SQL release last night (29th Novemeber). We were on 2012 with no service pack.
We've now been upgrade to SP4 and will monitor.
We are also having a patch made from SIMS to remove old intouch messages that are 3 years or older rather than the standard 1 year patch.
This is probably unrelated to our deadlock errors but we do have a large database size.
I'll keep you updated if any of the changes make a difference.
