Break Deadlocks Quicker

Is there a parameter within SQL Server 2000 Enterprise
Edition that will break deadlocks quicker and use less
resources?
Thanks,
MikeSQL Server usually detects deadlocks pretty quickly and when it does it
wastes no time killing one of the participants. You can however use a hint
called SET DEADLOCK_PRIORITY to potentially affect who gets killed.
Andrew J. Kelly SQL MVP
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:f55e01c43dcf$fb009320$a301280a@.phx.gbl...
> Is there a parameter within SQL Server 2000 Enterprise
> Edition that will break deadlocks quicker and use less
> resources?
> Thanks,
> Mike
>|||Mike,
you might want to check out
SET LOCK_TIMEOUT
SET DEADLOCK_PRIORITY
in BOL.
HTH,
Paul Ibison|||Though don't let that stop you coming to the route causes of the deadlocking
. SQL BOL gives a pretty good overview.
Alicia
www.sqlporn.co.uk