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