Does anyone have info on spinloops? We occasionally see processes denoted in sysprocesses as spinloops. These processes appear to block other users and we don't seem to able to kill them.

Any info on what gives rise to spinloops and/or how to kill them without recyling the SQL server would greatly appreciated.

Many thanks!