1 Answer
- Newest
- Most votes
- Most comments
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
answered 3 years ago
Relevant content
- asked 2 years ago
- asked 8 months ago
- Accepted Answerasked a year ago
- asked 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 2 years ago