Published 03 September 2018
This documentation highlights the available application settings that can be configured per installation depending on the needs. These can be configured through environment variables on the machine where SQL Data Catalog is installed on. In order these changes to take effect, you need to restart "Redgate SQL Data Catalog Service" ("SqlDataCatalog" as the name of the service) Windows Service.
Background Worker: Maximum Number of Concurrent Jobs
The maximum number of concurrent jobs that can execute in the background in order to fetch the information from the live data sources such as registered SQL Server instances. The default value is set to 3 times smaller than the processor count of the installed machine or 1 (if the former evaluates to 1).
For example, the below PowerShell script sets "4" as the the maximum number of concurrent jobs and restart the SEMvNext windows service for this change to take effect.
[Environment]::SetEnvironmentVariable('REDGATE_SqlDataCatalog_BackgroundWorker__MaximumNumberOfConcurrentJobs', '4', 'Machine') Get-Service -Name 'SqlDataCatalog' | Restart-Service
Background Worker: Minimum Time Period
For recurring jobs, this is the minimum time that must elapse between successive onsets of the job. The value is supposed to be represented in seconds. The default value is set to 15 minutes.
For example, the below PowerShell script sets "120" seconds as the the minimum time period and restart the SEMvNext windows service for this change to take effect.
[Environment]::SetEnvironmentVariable('REDGATE_SqlDataCatalog_BackgroundWorker__MinimumTimePeriodInSeconds', '120', 'Machine') Get-Service -Name 'SqlDataCatalog' | Restart-Service