Symptom
- Why does ASE show many spid's in LATCH SLEEP state?
- Killing a spid in 'latch sleep' will not be immediate because it is waiting for a latch held by another spid.
For example: Background House Keeper process HK GC in 'latch sleep' status locked lot of spids. Restarting ASE resolved the bottleneck. - Why did this happen?
- How to avoid it in future?
- What is the best way to resolving the "latch sleep" other than restarting ASE?
Read more...
Environment
SAP Sybase Adaptive Server Enterprise (ASE)
Product
SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions
Keywords
non-transactional, synchronization, mechanisms, physical, consistency, page, latch, wait, housekeeper, dbcc, lock_release, dbreboot , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.