SAP Knowledge Base Article - Preview

2577345 - Performance issue on an ASE 15.5 for linux

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

Sybase IQ 12.7

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.