SAP Knowledge Base Article - Preview

2542475 - Simple SQL queries have poor performance on HANA, in HANA Studio you see the alert ID : 60 Alert Sync/Async read ratio

Symptom

  • You have a general performance problem with HANA SQL queries.
  • While the performance issue exists, the following alert is also present in HANA Studio:

        pic2.PNG

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP HANA 1.0, platform edition
  • SAP HANA, platform edition 2.0 

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

 Sync/Async read ratio, warning, alert, IO performance,  hana server , KBA , HAN-DB-PERF , SAP HANA Database Performance , SV-PERF , Performance Problems , 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.