2577345 - Performance issue on an ASE 15.5 for linux | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.