General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Deadlocks in SQL Server
Been having a bout of dead locks in SQL server on a large network.
Our application uses ODBC SQL Passthrough to connect to SQL Server.
The application uses client side processing to handle updates in one atomic transaction in the following manner:-
1) Update sales invoice (1 header and 2 child) via SQL inserts
2) Generates a delivery order based on the sales invoice (1 header and 1 child) via SQL inserts
2) Update customer balances file via SQL inserts
3) Update inventory via SQL inserts
4) Update general ledger via SQL Insert
Surrogate keys are used for sales invoice and delivery orders documents.
We're having lots of dead locks lately and would like some guidance on tracing the source codes that are causing the deadlocks and fix it.
Thanks in advance.
Yau
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only