Majorly Deadlocks are Database Design problem but they are a performance problem as well because they can prevent 2 or
more processes from being able to process data. A deadlock chain can occur and impact hundreds of spids based on the data
access patterns, number of users, object dependencies, etc. Deadlocks could require a database design change, T-SQL coding
change to access the objects in the same order, separating reporting and OLTP applications, including NOLOCK statements in
SELECT queries that can accept dirty data, etc.
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment