Symptom
- Thread Utilization is incorrectly reported in sp_sysmon, for example:
Thread Utilization (OS %) User Busy System Busy Idle
------------------------- ------------ ------------ ----------
ThreadPool : syb_blocking_pool
Thread 2 (Work Queue Task) 1844 % 155.9 % 0.0 %
Thread 3 (Work Queue Task) 1844 % 155.9 % 0.0 %
Thread 4 (Work Queue Task) 1844 % 155.9 % 0.0 %
Thread 5 (Work Queue Task) 1844 % 155.9 % 0.0 %
------------------------- ------------ ------------ ----------
Pool Summary Total 7375.5 % 623.8 % 0.0 %
Average 1844 % 155.9 % 0.0 %
ThreadPool : syb_default_pool
Thread 6 (Engine 0) 1844 % 155.9 % 0.0 %
Thread 7 (Engine 1) 1844 % 155.9 % 0.0 %
....
Thread 42 (Engine 36) 1844 % 155.9 % 0.0 %
Thread 43 (Engine 37) 1844 % 155.9 % 0.0 %
------------------------- ------------ ------------ ----------
Pool Summary Total 70066.0 % 5925.7 % 0.0 %
Average 1844 % 155.9 % 0.0 %
ThreadPool : syb_system_pool
Thread 1 (Signal Handler) 1844 % 155.9 % 0.0 %
Thread 44 (NetController) 1844 % 155.9 % 0.0 %
Thread 45 (NetController) 1844 % 155.9 % 0.0 %
...
Thread 55 (DiskController) 1844 % 155.9 % 0.0 %
Thread 56 (CtlibController) 1844 % 155.9 % 0.0 %
------------------------- ------------ ------------ ----------
Pool Summary Total 25814.1 % 2183.2 % 0.0 %
Average 1844 % 155.9 % 0.0 %
------------------------- ------------ ------------ ----------
Server Summary Total 103256 % 8732.6 % 0.0 %
Average 1844 % 155.9 % 0.0 %
Adaptive Server threads are consuming 1120 CPU units.
Throughput (committed xacts per CPU unit) : 2.3
- The issue is observed after ASE upgrade to v.15.7 SP138 from v.15.7 SP137.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 SP138
- SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL05
- Linux
Product
Keywords
CR803935, CR#803935, 803935, CR795206, CR#795206, 795206, exceed, "100%", monThread, monitoring, MDA, Linux , 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.
SAP Knowledge Base Article - Preview