SAP Knowledge Base Article - Preview

2952272 - Periodic hanging of dataserver with i/o wait 0.00 in sar output

Symptom

  • Customer recently migrated ASE database from 15.7 to 16.0.  On 15.7 customer has regular i/o wait (but low < 1%) after migration to 16.0 customer experiences 0.00 i/o wait but every 23 minutes. So he has a big i/o wait which hang 10 secondes activity in dataserver. 
  • Customer sent some SAR output 

CPU %user %nice %system %iowait %steal %idle


10:49:01 all 0.49 0.00 0.27 0.00 0.00 99.23
10:50:01 all 1.55 0.00 0.38 3.01 0.00 95.06
10:51:01 all 0.57 0.00 0.35 0.00 0.00 99.08
10:52:01 all 0.52 0.00 0.26 0.00 0.00 99.21
10:53:01 all 0.82 0.00 0.73 0.00 0.00 98.44
10:49:01 all 0.49 0.00 0.27 0.00 0.00 99.23
10:50:01 all 1.55 0.00 0.38 3.01 0.00 95.06
10:51:01 all 0.57 0.00 0.35 0.00 0.00 99.08
10:52:01 all 0.52 0.00 0.26 0.00 0.00 99.21
10:53:01 all 0.82 0.00 0.73 0.00 0.00 98.44


Read more...

Environment

  • SAP ASE Adaptive Server Enterprise/16.0 SP03 PL08 HF1
  • Red Hat Enterprise Linux Server release 7.8 (Maipo)

Product

SAP Adaptive Server Enterprise 16.0

Keywords

i/o wait,cache controller,hanging,iowait,0.00 iowait,0.00 i/o wait,sar , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.