title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
---|---|---|---|---|---|---|---|---|
SQL Server Integration Services Scale Out Manager |
This article describes the Scale Out Manager tool which you can use to manager SSIS Scale Out |
haoqian |
haoqian |
12/19/2017 |
sql |
integration-services |
conceptual |
performance |
[!INCLUDEsqlserver-ssis]
Scale Out Manager is a management tool that lets you manage your entire SSIS Scale Out topology from a single app. It removes the burden of doing management tasks and running Transact-SQL commands on multiple computers.
There are two ways to open Scale Out Manager.
Open SQL Server Management Studio (SSMS) and connect to the SQL Server instance of Scale Out Master.
In Object Explorer, right-click SSISDB, and select Manage Scale Out.
Note
We recommend running SSMS as an administrator, since some Scale Out management operations, such as adding a Scale Out Worker, require administrative privilege.
Locate ManagementTool.exe
under %SystemDrive%\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\Management
. Right-click ManagementTool.exe and select Run as administrator.
After Scale Out Manager opens, enter the SQL Server instance name of Scale Out Master and connect to it to manage your Scale Out environment.
In Scale Out Manager, you can do the following things:
After connecting to SQL Server, if Scale Out is not enabled, you can select Enable to enable it.
The status of Scale Out Master is shown on the Dashboard page.
The status of Scale Out Worker is shown on the Worker Manager page. You can select each worker to see the individual status.
To add a Scale Out Worker, select + at the bottom of the Scale Out Worker list.
Enter the computer name of the Scale Out Worker you want to add and click Validate. The Scale Out Manager checks whether the current user has access to the certificate stores on the Scale Out Master and Scale Out Worker computers
If validation succeeds, Scale Out Manager tries to read the worker server configuration file and get the certificate thumbprint of the worker. For more info, see Scale Out Worker. If Scale Out Manager can't read the worker service configuration file, there are two alternative ways for you to provide the worker certificate.
-
You can enter the thumbprint of worker certificate directly.
-
Or, you can provide the certificate file.
After gathering information, Scale Out Manager describes the actions to be performed. Typically, these actions include installing the certificate, updating the worker service configuration file, and restarting the worker service.
In case the worker setting is not accessible, you have to update it manually and restart the worker service.
Select the Confirm checkbox and then select OK to start adding a Scale Out Worker.
To delete a Scale Out Worker, select the Scale Out Worker and then select - at the bottom of the Scale Out Worker list.
To enable or disable a Scale Out Worker, select the Scale Out Worker and then select Enable Worker or Disable Worker. If the worker is not offline, the status of the worker displayed in Scale Out Manager changes accordingly.
To edit the description of a Scale Out Worker, select the Scale Out Worker and then select Edit. After you finish editing the description, select Save.
For more info, see the following articles: