There are number of registry settings that can be changed to fine-tune the performance for specific environments or use cases.
For any of these settings to take effect it is important to restart the service after changing them.
The following table provides an overview of these
settings that can be found in:
|AdoCommandRetryPeriodSecs||If an ADO operation fails, this is the number of seconds the SMS Server will continue to retry the operation.|
|AdoCommandTimeoutSecs||The command timeout in the ADO layer.|
|AdoConnectionTimeoutSecs||The connection timeout in the ADO layer.|
|AdoLocking||The ADO locking type that will be used for all ADO operations.|