dead lock!

dead lock!

Post by Alex B » Fri, 22 Sep 2000 04:00:00



hi,

is there a way to designate a certain SP as the winner of all deadlocks?  I
have one SP that processes all incoming transactions and would really like
it to win any deadlock situation.

tia

 
 
 

dead lock!

Post by Keith Kratochvi » Fri, 22 Sep 2000 04:00:00


NOPE!
SQL Server will kill and rollback the "easier" transaction.

Keith


Quote:> hi,

> is there a way to designate a certain SP as the winner of all deadlocks?
I
> have one SP that processes all incoming transactions and would really like
> it to win any deadlock situation.

> tia


 
 
 

dead lock!

Post by Alex B » Fri, 22 Sep 2000 04:00:00


thanks for the reply!  that's definitely a bummer, since in this case, i
really need it to finish the "easy" transaction ...



> NOPE!
> SQL Server will kill and rollback the "easier" transaction.

> Keith



> > hi,

> > is there a way to designate a certain SP as the winner of all deadlocks?
> I
> > have one SP that processes all incoming transactions and would really
like
> > it to win any deadlock situation.

> > tia

 
 
 

dead lock!

Post by Erland Sommarsk » Fri, 22 Sep 2000 04:00:00



>is there a way to designate a certain SP as the winner of all deadlocks?  I
>have one SP that processes all incoming transactions and would really like
>it to win any deadlock situation.

No, but you say SET DEADLOCK_PRIORITY LOW, which means that you don't
mind being the loser. At least something.

--

 
 
 

dead lock!

Post by Brad Irb » Fri, 22 Sep 2000 04:00:00


you can't specify a winner, but you CAN specify a loser.  Check out


It sets priority by session, not SP, but it may help if you  have a specific
process that you want to win and another specific one that is usually
theother half of the deadlock and you want it to lose.

Brad Irby
VP Software Development
CRSD Inc.
www.crsdinc.com


Quote:> hi,

> is there a way to designate a certain SP as the winner of all deadlocks?
I
> have one SP that processes all incoming transactions and would really like
> it to win any deadlock situation.

> tia