Integration Services (SSIS) Scale Out Master

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

The Scale Out Master manages the Scale Out system through the SSISDB Catalog and the Scale Out Master service.

The SSISDB Catalog stores all the information for Scale Out Workers, packages, and executions. It provides the interface to enable a Scale Out Worker and execute packages in Scale Out. For more information, see Walkthrough: Set up Integration Services Scale Out and Run Packages in Integration Services.

The Scale Out Master service is a Windows service that is responsible for the communication with Scale Out Workers. It returns the status of package executions on Scale Out Workers over HTTPS and operates on the data in SSISDB.

Scale Out views and stored procedures in SSISDB

Views

• [catalog].[master_properties]
• [catalog].[worker_agents]

Stored procedures

• For managing Scale Out Workers:

  • [catalog].[disable_worker_agent]
  • [catalog].[enable_worker_agent]

• For running packages in Scale Out:

  • [catalog].[create_execution]
  • [catalog].[add_execution_worker]
  • [catalog].[start_execution]

Configure the Scale Out Master service

You configure the Scale Out Master service by using the <drive>:\Program Files\Microsoft SQL Server\140\DTS\Binn\MasterSettings.config file. You have to restart the service after updating the configuration file.

Configuration	Description	Default Value
PortNumber	The network port number used to communicate with a Scale Out Worker.	8391
SSLCertThumbprint	The thumbprint of the TLS/SSL certificate used to protect the communication with a Scale Out Worker.	The thumbprint of the TLS/SSL certificate specified during the Scale Out Master installation
SqlServerName	The name of the SQL Server that contains the SSISDB catalog. For example, ServerName\InstanceName.	The name of the SQL Server that is installed with the Scale Out Master.
CleanupCompletedJobsIntervalInMs	The interval for cleaning up completed execution jobs, in milliseconds.	43200000
DealWithExpiredTasksIntervalInMs	The interval for dealing with expired execution jobs, in milliseconds.	300000
MasterHeartbeatIntervalInMs	The interval for the Scale Out Master heartbeat, in milliseconds. This property specifies the interval at which Scale Out Master updates its online status in the SSISDB catalog.	30000
SqlConnectionTimeoutInSecs	The SQL connection timeout in seconds when connecting to SSISDB.	15

View the Scale Out Master service log

The Scale Out Master service log file is located in the <drive>:\Users\[account]\AppData\Local\SSIS\ScaleOut\Master folder.

The [account] parameter refers to the account running the Scale Out Master service. By default, this account is SSISScaleOutMaster140.

Next steps

Integration Services (SSIS) Scale Out Worker