MSSQL6.5 'Golden'/Rollback state problem

Hi, anyone knows if the 'golden' / rollback state in sql
6.5 causes the entire server to hang is a known problem?
Are there any advices as to what can be done to avoid
this problem from occurring in the future again? ThanksHi Kimkia.
Golden state applies to spids, not the server - so there is no direct
relationship I can see between a spid in golden and the server hanging. A
spid in golden state could cause an individual database to be inaccessible
but as far as I know, this shouldn't affect the whole server. Then again,
6.5 seems like a distant memory these days for me so perhaps someone else
could chip in with some more information for you.
As far as avoiding golden state is concerned - you should apply normal
deadlock / rollback avoidance techniques - keeping transactions short,
indexes up to date (to help keep transactions short & avoid deadlocks),
inspect regular deadlocks for coding mistakes such as accessing tables in
opposite orders. Also avoid doing major batch work in busy periods so that
you won't have to roll back large transactions during busy periods (during
which spids go golden)
HTH
Regards,
Greg Linwood
SQL Server MVP
"Kimkia" <ahkimkia@.hotmail.com> wrote in message
news:051d01c39dc3$ba897520$a601280a@.phx.gbl...
> Hi, anyone knows if the 'golden' / rollback state in sql
> 6.5 causes the entire server to hang is a known problem?
> Are there any advices as to what can be done to avoid
> this problem from occurring in the future again? Thanks