About Us
SSWUG Articles
Articles
FAQ
Administration
Backup/Restore
Connectivity
Development
General
Installation
OLAP
Replication
Transfer/move
Trouble
SQL 6.5
Scripts
Tips
Test Exams
Advertise
Download
History
Search
Traffic
Related Links
Add to Favorites
How do I resolve deadlocks?
Answer:
To minimize deadlock, you should (this is from SQL Server Books Online):
Access objects in the same order.
Avoid user interaction in transactions.
Keep transactions short and in one batch.
Use as low an isolation level as possible.
Use bound connections.
Use trace flag 1204 to get more information about locking. You can use SQL Profiler to monitor and identify the cause of a deadlock.
See also these links:
SQL Server 6.5: Some useful trace flags
SQL Server 7.0: Some useful trace flags
SQL Server 2000: Some useful trace flags
Visit
The SQL Server Worldwide User's Group
for all the latest news and information about
SQL Server, Oracle, DB2 and XML for developers and administrators
.
(c) 1997, 2010 Bits on the Wire, Inc