Hi,
I'm in the process of migrating our MSSQL database to Cassandra database in our DMS. However, the Total remaining time states around 43hours to complete the migration, is this expected for a 200MB database?
I read in the documentation that it takes approximately 1 hour for every 5GB of data.
Thanks,
Carlos
Hi Carlos,
The current time estimation is based on the total percentage completed within the current time elapsed. From the screenshot, I see that the migration is running for about 13 minutes, with a total percentage of 0.50% completed. If we extrapolate this, it would take 43 hours to reach 100%. So the calculation seems to make some sense.
If I look at how many rows you have in the Info column, in this case around 12000, it seems to take a very long time to migrate them. The migration of Info is at 66%, meaning about 8000 rows have been done in around 13 minutes. This indeed seems very slow.
Perhaps it is interesting to have a look at the load (CPU/memory/disk IO) of the server that is performing the migration.
Best regards,
Simon
Thanks Simon, I will have a look at that