1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
Actually by adjusting a couple settings in the task JSON downward I was able to reduce the total resources required on the source database.
See the MaxFullLoadSubTasks and CommitRate settings.
For MaxFullLoadSubTasks it generally corresponds to the number of tables processing at once, although number connections is multiples per table in my case. For CommitRate I lower this to 1000 to conserve all resources on our side, server and network, reduce overall stress.
Edited by: ted1111 on Oct 1, 2021 3:21 AM
Edited by: ted1111 on Oct 1, 2021 9:53 AM
répondu il y a 3 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a 4 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 6 mois