Wednesday 20 April 2011

ASE : Zombie processes in ASE

When you do not have the row in sysprocesses but you do have in
syslocks that is zombie  lock ( i.e. phantom lock )
You will need to either recycle ASE server or use  dbcc . If you are
using  ASE 12.5.4 or later version , you can try using 'dbcc
lock_release'

A phantom [lock] is when there is an entry in syslocks for
a spid,  but the spid does not exist in sysobjects (phantoms
have no body, just cast a shadow).  Phantom locks are usually
due to bugs in process cleanup in the ASE. 

1 comment:

  1. Where do sports toto win in 2020? - Sporting100
    What is the best way to win in 2020? betting limits: Even if you're betting at 100 percent, the odds on the top five selections will Betting 토토사이트 Limits: US Players Can Only Bet On Sports

    ReplyDelete