Symptom
Sybase 15.5 run on SuSE Linux 11 SP3 system, recently, the database CPU keep in a high level which makes our product run slowlly.
1) High CPU Uage
Kernel Utilization
------------------
Your Runnable Process Search Count is set to 2000
and I/O Polling Process Count is set to 10
Engine Busy Utilization CPU Busy I/O Busy Idle
------------------------ -------- -------- --------
Engine 0 70.6 % 0.0 % 29.4 %
Engine 1 37.2 % 0.0 % 62.8 %
Engine 2 74.4 % 0.0 % 25.6 %
Engine 3 51.9 % 0.0 % 48.1 %
Engine 4 73.8 % 0.0 % 26.3 %
...
Engine 30 34.7 % 0.0 % 65.3 %
Engine 31 54.4 % 0.0 % 45.6 %
------------------------ -------- -------- --------
Summary Total 1488.3 % 0.0 % 1711.7 %
Average 46.5 % 0.0 % 53.5 %
2) lower committed transactions
Transaction Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Committed Xacts 6.9 n/a 221 n/a
3) High spinlock contention on default data cache
Cache: default data cache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 76.0 %
Read more...
Environment
ASE 15.5 for Linux
Product
Keywords
"spinlock", "gobal cache partition number", "local cache partition number" , 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.