Sometimes when Offline Sync Service is syncing a large table (with a lot of data), it’s interesting to check the status of sync – to validate how many records have been already inserted. For this we can execute Uncommitted read in SQL Management Studio:
set transaction isolation level read uncommitted
go
begin transaction;
go
SELECT COUNT(*) FROM [AxRetailPOS_OfflineDB].[ax].[MY_TABLE_NAME]
SELECT COUNT(*) FROM [AxRetailPOS_OfflineDB].[ax].[INVENTTABLE]
SELECT COUNT(*) FROM [AxRetailPOS_OfflineDB].[ax].[CUSTTABLE]
SELECT COUNT(*) FROM [AxRetailPOS_OfflineDB].[ax].[ECORESPRODUCT]
SELECT COUNT(*) FROM [AxRetailPOS_OfflineDB].[ax].[PRICEDISCTABLE]
commit transaction;