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

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

Search for additional results

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