Proximity Placement Groups in Azure : Testing the Impact on Query Performance in HANA

Hello All,

I am into SAP Performance Optimization since many years and would like to share one of my case study about a performance issue on Azure. Sharing here for the benefit of other users in similar area.

Network Latency in SAP Environments:

Network latency is a very important metric to be measured, which has a direct impact on runtime of jobs or transactions run by users. Many SAP applications ( custom and standard ) run queries as part of application logic which requires multiple round-trips to database sometimes based on the program design. Examples could be a SELECT … UPTO 1 ROWS in a loop etc.

A slight increase in latency can multiply as the number of times the loop is run and fetching records from database. During a migration of SAP to a IaaS or on-premise provider,  it is difficult to identify these changes from an application level if the change is very insignificant per record, however it can multiply many fold if the logic is run in a loop.

If the change is too big, it could be picked up my many metrics from Solman like increase in DB response time etc,so it can be identified easily.

the detailed case study is published on SAP Blogs at https://blogs.sap.com/2020/09/23/proximity-placement-groups-in-azure-testing-the-impact-on-query-performance-in-hana/