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
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.