SAP Knowledge Base Article - Preview

2971885 - Some Metrics show up as 0 in monSysLoad - SAP ASE

Symptom

Some metrics show as 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) , Problem

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.