How can I estimate data transfer between SAP Application server and HANA DB server?

[dmn]

Hi

How can I estimate data transfer between SAP Application server and HANA DB server? I need the data to estimate data processing cost on load balancer used for DB cluster.

regards

Dilip

[ian_mchardy · Accepted solution]

Hi Dilip,

One way to do this might be to use the Emdedded Statistics Service view _SYS_STATISTICS.HOST_CONNECTIONS. See https://help.sap.com/docs/SAP_HANA_PLATFORM/85e6beaa64484eb88b47b34eabdf1326/3215e1e1400c4d42afc2c36... and https://help.sap.com/docs/SAP_HANA_PLATFORM/85e6beaa64484eb88b47b34eabdf1326/96a0a52b735c4fb9a450c64... for more information.

For example, to get the number of bytes sent/received in the last week, I think the following might be close to what you want:

select client_host, count(*), sum(RECEIVED_MESSAGE_SIZE+sent_message_size) as bytes_transferred from _SYS_STATISTICS.HOST_CONNECTIONS

where days_between(start_time, current_timestamp) < 7

group by client_host

Kind regards,

Ian

[dmn · Accepted solution]

Thanks Ian!