Symptom
- Queries doing a table scan when an index exists on the table
- Outdated statistics
- High spinlock contention
- Sp_sysmons shows very high I/O usage
Engine Utilization (Tick %) User Busy System Busy I/O Busy Idle
------------------------- ------------ ------------ ---------- ----------
ThreadPool : syb_default_pool
Engine 0 9.6 % 0.5 % 89.9 % 0.0 %
Engine 1 7.8 % 0.6 % 91.6 % 0.0 %
Engine 2 10.4 % 0.5 % 89.1 % 0.0 %
Engine 3 12.8 % 0.6 % 86.6 % 0.0 %
Engine 4 8.8 % 0.4 % 90.8 % 0.0 %
Engine 5 13.0 % 0.6 % 86.4 % 0.0 %
Average Runnable Tasks 1 min 5 min 15 min % of total
------------------------- ------------ ------------ ---------- ----------
ThreadPool : syb_default_pool
Global Queue 0.0 0.0 0.0 0.0 %
Engine 0 0.1 0.1 0.1 1.5 %
Engine 1 0.2 0.1 0.1 1.7 %
Engine 2 0.2 0.2 0.1 1.7 %
Engine 3 0.1 0.1 0.1 0.7 %
Engine 4 0.1 0.1 0.1 0.8 %
Engine 5 0.2 0.1 0.1 1.7 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
ThreadPool : syb_default_pool
Engine 0
Full Sleeps 28.8 0.0 8632 1.4 %
Interrupted Sleeps 0.7 0.0 219 0.0 %
Engine 1
Full Sleeps 29.3 0.0 8800 1.4 %
Interrupted Sleeps 0.8 0.0 240 0.0 %
Engine 2
Full Sleeps 28.1 0.0 8418 1.4 %
Interrupted Sleeps 0.7 0.0 197 0.0 %
Engine 3
Full Sleeps 27.5 0.0 8246 1.3 %
Interrupted Sleeps 0.7 0.0 204 0.0 %
Engine 4
Full Sleeps 28.3 0.0 8501 1.4 %
Interrupted Sleeps 0.7 0.0 211 0.0 %
Engine 5
Full Sleeps 28.2 0.0 8474 1.4 %
Interrupted Sleeps 0.8 0.0 239 0.0 %
Thread Utilization (OS %) User Busy System Busy Idle
------------------------- ------------ ------------ ----------
ThreadPool : syb_blocking_pool : no activity during sample
ThreadPool : syb_default_pool
Thread 13 (Engine 0) 10.9 % 0.7 % 88.5 %
Thread 14 (Engine 1) 9.3 % 0.5 % 90.3 %
Thread 15 (Engine 2) 11.6 % 0.6 % 87.8 %
Thread 16 (Engine 3) 14.2 % 0.8 % 85.1 %
Thread 17 (Engine 4) 10.4 % 0.5 % 89.1 %
Thread 18 (Engine 5) 14.7 % 0.8 % 84.5 %
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 on Sun Sparc and threaded mode only
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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.