SAP Knowledge Base Article - Preview

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

Symptom

  • Performance impact, potentially very slow performance where ASE server almost halts
  • Procedure Cache is not full, usage can be as low as ~50% 
  • There is a (very) procedure cache spinlock contention (rproccache_spin)
  • 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
SAP Adaptive Server Enterprise (ASE) 16.0

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 for Me (Login required).

Search for additional results

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