|
Posted by Robert Klemme on 04/12/06 12:06
laststubborn wrote:
> Hi everybody,
>
> We have a very large database and high transaction volume. Time to time
> these transactions are locking each other and decrease the performance
> of the database. Is there any way that I can automate the killing
> process when blocking and deadlock time is exceeded in certain time
> elipsade? Can somebody help me on this please?
If SQL Server detects a deadlock it will kill one of the two involved TX
automatically. But you should really change your app to prevent these
deadlocks.
You probably cannot do much about normal locking as this is expected
behavior other than probably optimizing your SQL to make it faster.
HTH
robert
Navigation:
[Reply to this message]
|