We have huge amount of load at sql server db side due to streamsets and we want to reduce the same. We are using Streamsets sql server cdc client to pull data from 500 sql server tables to Snowflake. Can you please help us below questions:
- Is there a way to reduce frequency with which stream sets cdc client connect to sql server? We have used queries per second parameter as 1 to reduce the number of queries running at source. please let me know if we can do anything?
- And we see huge number of select max($__$seqval) running. Is this expected? Thanks!
Queries per Second is a correct way to to control throughput. You can use also positive values smaller then 1, like 0.1. The queries for seqval are necessary, yes.