Edge Sync services running very slowly

Ignition
1

Hi all,

I have two edge gateways syncing tag historian to a central Ignition gateway. It seems to be syncing data but at a painfully slow rate. Me messing around has most likely made it start over again, so historical data is days behind on the central server. I can see Store and forward guaranteeing data points due to duplicates.

ava.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'PK__sqlt_dat__BE126DD19E725D33'. Cannot insert duplicate key in object 'dbo.sqlt_data_4_2024_09'. The duplicate key value is (151, 1725884620199).

Central and mssql is running in Azure, VPN tunnels to the two Edge gateways.

Bandwith to the Edge is 20 mbit. CPU and Memory - no issues.

Shared execution engine at the Edge says that sync manager - edge historian is idle (?).

Tried creating a new db connection and changed Remote history provider to this. Same rate.

Changing Remote History sync settings makes msg/sec (Gateway network) drop.

Edge, 10 messages/sec?

Skjermbilde 2024-09-25 085229
Skjermbilde 2024-09-25 0852291437×796 39.7 KB

Most config changes makes the inserts/sec drop.

I'm in contact with support, but time zone differences makes it a bit challenging.

Any ideas? All suggestions is much appreciated.

2

Did you give the edge gateways different names?

3

Yes, they have unique names linked to their location.

Managed to increase the rate by changing que priority on the edge to highest before changing sync frequency to 1 sec and 250 000 on max batch size.

30 kb/s -> 230 kb/s. Still plenty of bandwidth.

1 Like
4

Since it is the one of the topics where I tried to find help I will leave a note here:
I learned that Edge device OS time must be correct to get the proper timestamps to the main gateway database. I was thinking that there are issues with Sync or Store and Forward settings (There was a delay with tag history and it looked like the data sync is not speedy enough).

5

Good thing to check. Time sync is also important for UA-tags, so we always make sure both PLC and all of the IGN gateways are synced to the same time server - in some cases the central gateway is running time services for all connected devices.

I really hope Sync will be improved in 8.3... :thinking:

image
image782×308 21.9 KB