Symptom
sp_sysmons are showing high Spinlock contention in the default data cache, what should be done next?
From the Data Cache Management the following is seen:
-------------------------------------------------------------------------------
Cache: default data cache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 16.4 %
Utilization n/a n/a n/a 99.3 %
Cache Searches
Cache Hits 181775.1 13419.6 5998578 100.0 %
Found in Wash 996.3 73.6 32879 0.5 %
Cache Misses 1.9 0.1 63 0.0 %
------------------------- ------------ ------------ ---------- ----------
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16,0
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
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.