cancel
Showing results for 
Search instead for 
Did you mean: 

How to find the remote subscription rate per hour?

SAPSupport
Employee
Employee
0 Kudos
125

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
xiaoming_wu
Product and Topic Expert
Product and Topic Expert
0 Kudos
I don't think we have the change rate collected. You can see the statistics for mssqllogreaderadapter, filter by component https://help.sap.com/docs/HANA_SMART_DATA_INTEGRATION/d60a5abb34d246cdb4ab7a4f6b9e3c93/0bd646bbaf934... Best regards Helen