Forum Discussion
Juergen530
Oct 18, 2024Copper Contributor
Strange behaviour using temp tables with a static named index (deadlock) and an individual named idx
Hello, my script looks similar to the following script. This script is getting called very often (parallel). In this version it sometimes results in a deadlock situation. The deadlock happens only ...
olafhelper
Oct 21, 2024Bronze Contributor
The deadlock happens only between two or more calls of this script.
The the deadlock graph would be of interest.
Deadlocks guide - SQL Server | Microsoft Learn
Save deadlock graphs (SQL Server Profiler) - SQL Server | Microsoft Learn
Juergen530
Oct 21, 2024Copper Contributor