SAP HANA – A Query on Multiple Nodes can be Slower

In distributed system, query execution can be routed to other nodes for better performance. However, the network used may impact performance.
In distributed system, query execution can be routed to other nodes for better performance. However, there is chance of having slow performance in the case where the network used for transferring intermediate results generated during query execution is slow or where there is an inefficient network configuration.

 

Root cause: A misconfigured network can lead slow queries.

Required Action: Check your network configuration and its bandwidth/latency among SAP HANA servers. For more information see Network View and SAP Note 2183363 – Configuration of SAP HANA internal network

 

Root cause: Due to statement routing and huge data transfer among distributed nodes, it can lead to the difference of query execution by the difference of anchor nodes.

Required Action: Check how much data is transferred among distributed nodes and the network performance.

For more information see Performance Trace and Analyzing SQL Execution with the Plan Visualizer. Then consider the locations of joined tables to reduce transferred intermediate result size.

Leave a Reply