Symptom
- CPU uilization spikes up.
- sp_sysmon reports show spinlock contention on a named cache going to 29%.
- The spinmon reports show a new spinlock "Sched Q" for this new spinlock.
- SCN Community chat Spinlocks on "Sched Q" suggests to turn off parameter "aggressive task stealing" to improve performance.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 SP134 and higher
Product
SAP Adaptive Server Enterprise 15.7
Keywords
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.