Hi:

I have a .net web application and  I am getting a lot of deadlocks.   My
system processes a lot of real-time transactions  daily.   In addition ,
there are like 3 DTS packages running.    The problem is that I am getting a
lot of deadlock and based on the history of the pakages I would say that is
happening because the packages take the control and kill the processes that
are tying to run at the same time.

Is there a way to try to reduce this dead-lock assigning especific features
to the packages.

Thanks

I don't think there are any issues specific to DTS packages that cause
deadlocking. A package could be excuting almost anything, so provide more
details about what type of selects / updates / inserts the package is
performing and also the nature of the transactions that are being blocked.

Read up in Books Online about "set transaction isolation level". Consider
using a lower isolation level, like read uncommitted. Basically, this allows
a process to read data currently locked by another transaction. Just
understand what "dirty reads", "nonrepeatable reads", etc. are and whether
or not they would present a significant problem in the specific case of your
queries.

Also, for what it's worth, here are my bookmarks for SQL Server deadlocking:
Deadlocking
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_7a_8i93.asp
INF: Analyzing and Avoiding Deadlocks in SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;169960
Tracing Deadlocks
http://www.sqlservercentral.com/columnists/skumar/tracingdeadlocks.asp
Minimizing Deadlocks
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_7a_3hdf.asp
SQL Server technical bulletin - How to resolve a deadlock
http://support.microsoft.com/default.aspx?scid=kb;en-us;832524


Show quoteHide quote

Getting an unused number from a set of numbers?
Design: multiple columns for primary key
Whats Wrong with the Query?
TSQL Debugger Oddity
Newbie:UNION with SELECT TOP