I have merge pull subscription with parameterized filter (dynamic snapshot), I have automatically generate snapshots option enabled. However, my data changes very frequently, sometimes 100s of records in few mins.
In such cases, I would like to determine the number of merge incremental data changes and if it exceeds a certain number(say 100 records), I want to generate a new dynamic snapshot and reinitialize the subscription.
Please let me know which tables should I looks for to determine the merge incremental data changes that are pushed to subscriber.
Whenever there is bulk upload(not bulk commands, huge data inserted in a short interval) to the tables, I want to create a snapshot and apply to subscribers.
How do I find out number of changes happened after the last snapshot generation?
