We are experiencing deadlocks in our production environment. Seems to be the victim and winner are the same spid's. We rebuild/reorganize indexes daily and we dont find any missing indexes.
Have you guys ever encountered this scenario and if so how did you guys solve it? Any suggestions are appreciated.
- the deadlock XML: https://justpaste.it/6xasd
- and the query plan: https://www.brentozar.com/pastetheplan/?id=ryBbs-XPQ
We are on SQL Server 2017 SP2.