December 17, 2025 at 6:52 am
I've come across what appears to be a strange deadlock anomaly. As seen in the attached image/XML, a typical deadlock is shown (bottom), but then a completely isolated process graph is also shown (top).
The top section has appeared in multiple deadlocks on different unrelated databases/app processes. It doesn't appear to be involved in the bottom deadlock at all. The top process looks to just be a normal parallel query execution being captured in the XML for some reason.
I don't believe I've ever seen this before. Has anyone else come across this?
Server info
Microsoft SQL Server 2022 (RTM-CU20-GDR) (KB5063814) - 16.0.4210.1
December 18, 2025 at 7:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 20, 2025 at 8:28 pm
Strange indeed.
Did you replay it ( e.g.using the free PlanExplorer )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 21, 2025 at 11:05 pm
Hey Johan,
I have replayed it using SQL Sentry Plan Explorer, though unfortunately it doesn't shed any more light on it. The two sections aren't linked and both run independently before the actual deadlock occurs. I'm thinking (and hoping) it's just a visual bug, though I figured I'd ask in case anyone else has come across it.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply