Monitor sample rate gives the number of rows processed before Data Services writes information to the monitor log file and updates job events. Data Services writes information about the status of each source, target, or transform. For example, if this value is set as 1000, Data Services updates the logs after processing 1,000 rows. The default is 1000.
With a higher Monitor Sample Rate, Data Services collects more statistics before updating the log file. Hence the instances of I/O operation are reduced. This in turn will avoid higher elapsed time of job execution. However, with a higher monitor rate, there is more lag between displaying the errors, if any.
Right click on the job. Select ‘Properties’. In the “Execution Options” tab, give the monitor sample rate.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
11 | |
5 | |
5 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |