SAP Knowledge Base Article - Preview

2771627 - How to verify HANA network Client I/O historical data

Symptom

  • SAP KBA 2081065 - Troubleshooting SAP HANA Network provides analysis instructions for network performance verification like Round Trip Time (RTT) between Server and Client.

  • To analyze the Round Trip Time (RTT), the script SQL: "HANA_Network_Clients" from SAP Note 1969700 - SQL Statement Collection for SAP HANA can be used.
    However, this information is only available during the time the SQL client network I/O trace has been enabled.

  • Accordingly to SAP KBA 2222200 - FAQ: SAP HANA Network,
    "SQL client network I/O information, only available if SQL client network I/O trace is activated"

  • This How-to provides a solution how to keep this data persistent and how to modify the SQL: "HANA_Network_Clients" script for later analyzing purposes.


Read more...

Environment

  • HANA 1.0
  • HANA 2.0 

Product

SAP Supply Chain Management 7.0

Keywords

KBA , HAN-DB , SAP HANA Database , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , 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.