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.