Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deadlock revisited
Message
 
 
À
15/02/2009 19:00:11
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2005
Application:
Web
Divers
Thread ID:
01381607
Message ID:
01382159
Vues:
61
>Ok, I see. Let me check that. That's probably what causes this. I also got that one one more time today and the traffic was low. So, it is certainly related to another hit that is affecting this. I will let you know.

It's not a simple tasks to avoid deadlocks sometimes. You should read more on deadlocks, what causes them and how to avoid them.
In general, the most common cause of deadlock is when statement 1 locks table A and than B and Statement 2 locks table B and Then A. It's simplified example but may give you an idea where to look.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform