SAP Knowledge Base Article - Preview

2971885 - Several metrics show all values as 0.0 in monSysLoad - SAP ASE

Symptom

Some metrics show as 0.0 in monSysLoad table:

  • disk reads per second 
  • disk writes per second 
  • network reads per second
  • network writes per second

For example:

1> use master
2> go
1> select * from monSysLoad
2> go
 StatisticID InstanceID EngineNumber Sample     SteadyState   Avg_1min      Avg_5min      Avg_15min        ...  Statistic              
 ----------- ---------- ------------    ------------ ----------- -------------       ------------- -------------    ... -------------------------
           1          0            0              0.000000   12.501516      6.140460      6.250537      6.219381           ... percent user busy       
           2          0            0              0.000000    0.012324      0.031914      0.029139      0.016839            ... percent system busy     
           3          0            0              0.000000    0.176387      0.000363      0.032794      0.049886            ... percent i/o busy        
           4          0            0              0.000000    0.239181      0.117441      0.080685      0.065639            ... run queue length        
           5          0            0              0.000000    0.001849      0.000000      0.000000      0.000000            ... kernel run queue length 
           6          0            0              0.000000    0.002342      0.000000      0.000076      0.000929            ... outstanding disk i/os    
           7          0            0              0.000000    0.000000      0.000000      0.000000      0.000000            ... disk reads per second   
           8          0            0              0.000000    0.000000      0.000000      0.000000      0.000000            ... disk writes per second  
           9          0            0              0.000000    0.000000      0.000000      0.000000      0.000000            ... network reads per second
          10         0            0              0.000000    0.000000      0.000000      0.000000      0.000000            ... network writes per second

(10 rows affected)  
1>


Read more...

Environment

  • SAP Adaptive Server Enterprise ASE 15.7
  • SAP Adaptive Server Enterprise ASE 16.0
  • SAP Adaptive Server Enterprise ASE 15.7 Cluster Edition
  • SAP Adaptive Server Enterprise ASE 16.0 Cluster Edition

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition

Keywords

monSysLoad, disk reads per second, disk writes per second, network reads per second, network writes per second , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , How To

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.