David McGaughy 22.Oct.10 03:13 PM a Web browser LEILEI - 7.0Windows
I have multiple, similar LEI Notes to SQL Server replication activities that all run quickly, many <20 seconds. But, one is taking up to a hour. It deals with a similar number of records as the others. Indexes seem to be created correctly. Can someone suggest other areas to investigate?
Here are the stats from what should be the biggest job:
Statistics
Elapsed Time: 00:02:04
Records Fetched From All Connectors: 37622
Records Inserted From All Connectors: 0
Records Updated From All Connectors: 0
Records Removed From All Connectors: 0
Here are the stats from the problem job:
Statistics
Elapsed Time: 00:41:35
Records Fetched From All Connectors: 4095
Records Inserted From All Connectors: 0
Records Updated From All Connectors: 0
Records Removed From All Connectors: 0