SAP Knowledge Base Article - Preview

2438941 - Thread Utilization is incorrectly reported in sp_sysmon - SAP ASE 15.7 SP138 and 16.0 SP02 PL05

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

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.