MSSQL Transaction Deadlock Error
Issue
You may receive an error like the following in your DotNetNuke Event Log:
Transaction (Process ID ##) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Cause
This issue occurs when two SQL commands run at exactly the same and need to modify the exact same data in different ways. This results in both SQL commands waiting for the other one to finish executing, causing an "infinite wait loop". SQL server then detects the infinite wait loop and terminates one of the SQL commands. This issue typically only occurs on high usage websites that have large amounts of data (such as a document repository, shopping cart, or forum).
Resolution
You will need to contact the module vendor for a resolution. If the issue is actively occurring, you may contact our technical support and we may be able to provide information regarding the module causing the error.
When diagnosing MS SQL performance issues, our technicians recommend DataWizard. This tool is available to our dedicated server clients through the SQL Analyzer tool in the Control Suite.
Article ID: 498, Created: April 9, 2012 at 4:50 PM, Modified: August 26, 2014 at 9:16 AM