cancel
Showing results for 
Search instead for 
Did you mean: 

How to find the remote subscription rate per hour?

SAPSupport
Employee
Employee
0 Kudos
153

We would like to know how can we measure a data throughput - size of data transferred from source database to the target HANA database. Is there any query that we can use to see the data getting transferred? 

We are using MssqlLogReaderAdapter to capture data changes at the MSSQL DB log (CDC mode) file and replicate data to HANA, is there a HANA table or view that we can query against to find out how many records/data size being processed by MssqlLogReaderAdapter per hour/day.

We would like to know how we can find the table modification rate per hour.


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.
View Entire Topic
SAPSupport
Employee
Employee
0 Kudos

These statistics are recorded periodically by the dpagent and sent to the HANA system. For HANA Cloud the statistics can be viewed in M_REMOTE_SOURCE_STATISTICS, for help interpreting that data refer to the monitoring statistics reference: https://help.sap.com/docs/HANA_SMART_DATA_INTEGRATION/d60a5abb34d246cdb4ab7a4f6b9e3c93/0bd646bbaf934...

The statistics are presented as a snapshot in time, for example statistic ID #10021 "INSERT records processed by applier (per subscription)" will record the number of inserts applied for a remote subscription in the time between the previous statistics snapshot and the current snapshot. That snapshot interval is given by dpserver.ini > remote_source_statistics > collect_interval (default 300 seconds). This interval can be increased to view the statistics at your preferred level such as 3600 for hourly or 86400 for daily rates.