Symptom
- A series of sp_sysmons were run to see how things are running.
- This run is the normal for this duration, and it has not been an issue in the past.
- In the reports were see a lot of negative numbers, for example:
Engine 18 -0.3 0.0 -1 -1.8 %
Dirty -0.5 0.0 -2 -28.6 %
DOL Shrink -0.3 0.0 -1 -0.1 %
by Unpin -0.3 0.0 -1 -0.2 %
Page Splits -0.3 0.0 -1 n/a
Granted -0.3 0.0 -1 100.0 %
Cache Hits -0.3 1.0 -1 100.0 %
Non-APF -0.3 0.0 -1 -10.0 %
Waited -0.3 0.0 -1 -0.0 %
Total I/Os -0.3 0.0 -1 -0.1 %
Total Scans -0.8 3.0 -3
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.x
Product
SAP Adaptive Server Enterprise 16.0
Keywords
sp_sysmon negative numbers, sp_sysmon output troubleshooting, ASE performance monitoring, sp_sysmon sample time adjustment, installmaster post
- upgrade, multiple sp_sysmon collections, negative numbers in ASE monitoring, sp_sysmon manual, ASE database resolution, ASE monitoring discrepancies, ASE troubleshooting guide, ASE sp_sysmon anomalies
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.
SAP Knowledge Base Article - Preview