Using the Modify SQL Server Maximum Worker Threads Parameter screen

Note the values displayed for each SQL Server instance in the list.

• The Current Max Worker Threads column of the this screen displays the current setting for each SQL Server instance.
• The New Max Worker Threads column of this screen displays the recommended setting for each SQL Server instance as determined by the maximum number of databases that can be backed up concurrently.

Before proceeding, note the "Apply new maximum worker thread value for each instance" option. This option is selected by default.

If you leave this option selected when you click Next, the values in the New Max Worker Threads column will be applied to the SQL Server instances after you complete the Configuration Wizard sequence. Every affected SQL Server instance will be restarted in order for the new parameter value to take effect.

Choose whether you want to modify the maximum SQL Server worker threads as indicated by the values in the New Max Worker Threads column.

If...

Then...

You want to leave the current values unchanged for all of the SQL Server instances

1. Deselect the "Apply new maximum worker thread value for each instance" option.
2. Click Next.

Result

The SQL Server values will not be modified, and you have finished this procedure; the SnapInfo Directory Type screen appears.

You want to apply the recommended values for all of the SQL Server instances

1. Leave the "Apply new maximum worker thread value for each instance" option selected
2. Click Next.

Result

The values will be modified, and you have finished this procedure; the SnapInfo Directory Type screen appears.

You want to edit the recommended value for one or more of the SQL Server instances before applying the changes

1. Leave the "Apply new maximum worker thread value for each instance" option selected.
2. Proceed to Step 4.

Select the SQL Server instance whose recommended maximum worker thread count you want to modify, then click Edit New Value.

Result

The Set Up SQL Server Maximum Worker Threads dialog box appears.

In the New Maximum Worker Threads box, enter the new value.

You can apply this change to all SQL Server instances, or you can make this change individually for other SQL Server instances.

• If you want to apply this change to all SQL Server instances, select the option labeled "Set the maximum worker threads for all SQL Server instances."
• If you want to modify the maximum worker thread count for another individual SQL Server instance, go to Step 1.

Click OK to close the dialog box.

Result

In the Modify SQL Server Maximum Worker Threads Parameter screen, the value New Max Worker Threads column is updated to reflect the new setting you specified.

Note
The instances whose values you modified will be restarted when you click Finish in the Completing the Configuration Wizard screen.

If you want to modify the maximum SQL Server worker threads for another SQL Server instance, repeat Step 4 through Step 7.