SAP Knowledge Base Article - Preview

1920548 - spid waiting for a latch cannot be killed immediately - SAP ASE

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.