SAP Knowledge Base Article - Preview

3150098 - High spinlock contention on SSQLCACHE_SPIN when proc cache memory is low

Symptom

Most common stacks from ASE sampling data (taken at the same time as above spinlock monitoring data) :

Threads (612):
202179666..3 1075119108..8 1020987588..25 1786054445..27 940905702..38 1102124497..49 1636501122..59 892929793..67 837491597..69 893325677..76...
pc: 0x000000000223c6e7 pausenonatomic+0x9
pc: 0x0000000001a6b5d7 kbfalloc+0x1737
pc: 0x0000000001a69e5d ubfallocf+0x1d
pc: 0x000000000104a27a ssql_save_SQL+0x195c
pc: 0x0000000001053327 sqt_put_in_stmtcache+0x159
pc: 0x000000000207e5ef s_compile+0x2f3f
pc: 0x0000000001a54318 sequencer+0x13c8
pc: 0x0000000001a49ae6 execproc+0xcf6
pc: 0x0000000001a379f6 s_execute+0x4696
pc: 0x0000000001a53c63 sequencer+0xd13
pc: 0x00000000008f0973 tdsrecv__dynexec+0x1a6
pc: 0x0000000001ab54d0 tdsrecv_dynamic+0x410
pc: 0x00000000017fde69 conn_hdlr+0x1969


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL08 HF1 for Business Suite
  • SAP Enterprise Resource Planning (ERP) 6.0

Product

SAP ERP 6.0

Keywords

CR#825063, CR825063, 825063 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.