On the Data tab, you can configure the following settings for SQL Server data source:
|Monitor changes to data in the database tables||
Enable monitoring of changes to data stored in the database tables hosted on the SQL Server.
NOTE: If you plan to enable this option, make sure the account that runs the SQL Server service on the monitored instance has at least read permissions in the Active Directory domain (e.g., it does not run under a local user account). Otherwise, enabling this option may lead to issues when altering databases on the monitored SQL Server instances.
|Data collection mode|
|Changes (per transaction) to collect and report:||
Specify how many changes per a database transaction you want to be collected. For example, you can limit this number to 10 changes per transaction, or collect all changes.
NOTE: It is recommended to adjust this setting carefully, as collecting large number of changes from a highly-transactional server may affect its performance.
To specify what data changes must be monitored, create at least one inclusion rule.
NOTE: Exclusion rules are optional.
Click Add Rule and configure the following:
These filters will be applied using AND logic. Wildcard (*) is supported and can be used to replace any number of characters.