After upgrading to ASE 15.7 SP 136 HF1, CPU is extremely high and performance has degraded.
Review of the monSpinlockActivity data shows high contention for tablockspins, Pdes Chain Spinlocks and/or high fglockspins.
Looking at ASE stacktraces of running spids during poor performance will show them waiting on spinlocks and somewhere in the stacktrace will be the routine db_is_inmemory_db
- SAP Adaptive Server Enterprise (ASE)
- SAP Adaptive Server Entrprise 15.7 SP136, SP136HF1, SP137
- SAP Adaptive Server Enterprise 16.0 SP01 PL03 through SP02 PL04HF1
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
tablockspins, SP136, HF1, HF 1 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis 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.