SAP Knowledge Base Article - Preview

2234801 - High procedure cache spinlock contention when procedure cache is not full. - SAP ASE 15.7

Symptom

  • Very slow performance (ASE server almost halts).
  • Procedure Cache is only ~50% full (6gb/13gb in this case).
  • There is a very high percentage (96%) of Procedure Cache spinlock contention.
  • Indicative monSpinlockActivity output:

SpinlockName       SlotID Grabs   Spins   Waits Contention  
-----------------------------------------------------------
SSQLCACHE_SPIN 1407 177743 196843 4311 2.42
Resource->rproccache_spin 1401 12567 1223638074 12100 96.28


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

ELC, engine, local, percent, traceflag, trace, flag, 753, 757, 758, proc_cache(free_unused), free_unused, proc_cache, memory, fragmentation, rproccache_spin, autotune, procedure cache memory pool, allocate a large block, performance, engine local cache percent , 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.