SQLHELPER_CONNECTION_COUNT (Parameter)

Parameter: SQLHELPER_CONNECTION_COUNT

Definition

The total number of connections to open on an instance of the Core Database

Description and Use

This system parameter specifies the total number of connections to open on an instance of the Core Database. If the Core Database is multi-instances, the overall number of opened connections is a multiple of this total number.

The value of this parameter must be correlated to the total number of threads running in each instance of the SAP CC system. If the number of connections to the Core Database is too small compared to the total number of threads running in the instance of the SAP CC system, the threads are not able to render the service because they do not find any available connection to perform their database requests.

Recommendation

SAP recommends that you set up the parameter value to the total number of threads used by the instance of the SAP CC system. But if it is not possible (too many threads in comparison with the Core Database capabilities), SAP recommends that you reduce the number of threads for the least used services.

System Configuration (Advanced): Tuning

Fine-Tuning the Parameter Value

You can fine-tune the parameter values. For each type of instances in your SAP CC system, see the SAP CC Sizing and Performance Tuning Guide.

Syntax and Constraints

Defined Constraints

The SAP CC Core Server system verifies the following constraints:

Instance Type	Constraint
Rater instances	The parameter must be greater than or equal to (MULTICAST_SERVER_THREAD_COUNT + STATEFUL_SERVICE_THREAD_COUNT + STATEFUL_SERVICE_SQL_UPDATE_POOL_SIZE + STATELESS_SERVICE_THREAD_COUNT + BATCH_SERVICE_THREAD_COUNT + ALLOWANCE_SERVICE_THREAD_COUNT + CACHE_WARMUP_THREAD_COUNT + RENEW_RESERVATION_RESEND_THREAD_COUNT + SPENDING_STATUS_REPORT_RESEND_THREAD_COUNT + (1 when ITEM_FILE_SEQUENCE_ENABLED is enabled; 0 otherwise ) + (ACTIVATION_THREAD_COUNT + 1) + (CLEANUP_THREAD_COUNT + 1) + (ALLOWANCES_PURGE_THREAD_COUNT + 1)) . The parameter must be greater than or equal to 1 .
Updater instances	The parameter must be greater than or equal to (MULTICAST_SERVER_THREAD_COUNT + HTTP_SERVER_THREAD_COUNT + WS_SERVER_THREAD_COUNT + PNR_BULK_THREAD_COUNT + (1 when TRANSPORT_SCHEDULER_ENABLED is enabled; 0 otherwise )) . The parameter must be greater than or equal to 1 .
Guider instances	The parameter must be greater than or equal to (MULTICAST_SERVER_THREAD_COUNT + STATEFUL_SERVICE_THREAD_COUNT + CACHE_WARMUP_THREAD_COUNT) . The parameter must be greater than or equal to 1 .
Bulkloader instances	The parameter must be greater than or equal to (MULTICAST_SERVER_THREAD_COUNT + (1 when ITEM_FILE_SEQUENCE_ENABLED is enabled; 0 otherwise )) . The parameter must be greater than or equal to 1 .
Taxer instances	The parameter must be greater than or equal to (MULTICAST_SERVER_THREAD_COUNT + STATEFUL_SERVICE_THREAD_COUNT) . The parameter must be greater than or equal to 1 .
Dispatcher instances	The parameter must be greater than or equal to (DISPATCHER_SERVER_THREAD_COUNT + HTTP_SERVER_THREAD_COUNT + WS_SERVER_THREAD_COUNT + MULTICAST_SERVER_THREAD_COUNT) . The parameter must be greater than or equal to 1 .

Technical Details

For more information, consult this section.

Name

SQLHELPER_CONNECTION_COUNT

The total number of connections to open on an instance of the Core Database

Category Parameter

Type Integer

Access (RO/RW)

RW(+): Dynamic Read / Static and Dynamic Write

An immediate change is possible but is temporary. When it is relevant, change the permanent settings used by the SAP CC Core Server system when it restarts.

Use the Admin+ user interface to change the runtime values or the permanent values of this system parameter in an instance of the SAP CC Core Server system or in multiple instances.

Groups

Instance Types

This system parameter is available in the following types of instances in a running SAP CC Core Server system:

rater, updater, guider, bulkloader, taxer, dispatcher

Default Values (Factory Settings)

The predefined default values are:

Instance Type	Value
Rater	`27`
Updater	`16`
Guider	`8`
Bulkloader	`5`
Taxer	`8`
Dispatcher	`20`

You can use a default value to reset the runtime value or the restart value (persistent) in the Admin+ user interface.

Note

A default value is part of the factory settings of the SAP CC Core Server systems. It differs from the original value set during the installation or after the Customizing activities.

In Admin+, you can reset a parameter value to this default value, but it is not recommended:

This value may differ from the original value set during the installation of your SAP CC system.
Note that it may also differ from the value defined by the implementation project team and set during the Implementation Phase of the integration project.

Verify the values in your running SAP CC systems before to use the reset command.

Constraints

The SAP CC system checks the following constraints:

Rater instances	The parameter must be greater than or equal to (MULTICAST_SERVER_THREAD_COUNT + STATEFUL_SERVICE_THREAD_COUNT + STATEFUL_SERVICE_SQL_UPDATE_POOL_SIZE + STATELESS_SERVICE_THREAD_COUNT + BATCH_SERVICE_THREAD_COUNT + ALLOWANCE_SERVICE_THREAD_COUNT + CACHE_WARMUP_THREAD_COUNT + RENEW_RESERVATION_RESEND_THREAD_COUNT + SPENDING_STATUS_REPORT_RESEND_THREAD_COUNT + (1 when ITEM_FILE_SEQUENCE_ENABLED is enabled; 0 otherwise ) + (ACTIVATION_THREAD_COUNT + 1) + (CLEANUP_THREAD_COUNT + 1) + (ALLOWANCES_PURGE_THREAD_COUNT + 1)) . The parameter must be greater than or equal to 1 .
Updater instances	The parameter must be greater than or equal to (MULTICAST_SERVER_THREAD_COUNT + HTTP_SERVER_THREAD_COUNT + WS_SERVER_THREAD_COUNT + PNR_BULK_THREAD_COUNT + (1 when TRANSPORT_SCHEDULER_ENABLED is enabled; 0 otherwise )) . The parameter must be greater than or equal to 1 .
Guider instances	The parameter must be greater than or equal to (MULTICAST_SERVER_THREAD_COUNT + STATEFUL_SERVICE_THREAD_COUNT + CACHE_WARMUP_THREAD_COUNT) . The parameter must be greater than or equal to 1 .
Bulkloader instances	The parameter must be greater than or equal to (MULTICAST_SERVER_THREAD_COUNT + (1 when ITEM_FILE_SEQUENCE_ENABLED is enabled; 0 otherwise )) . The parameter must be greater than or equal to 1 .
Taxer instances	The parameter must be greater than or equal to (MULTICAST_SERVER_THREAD_COUNT + STATEFUL_SERVICE_THREAD_COUNT) . The parameter must be greater than or equal to 1 .
Dispatcher instances	The parameter must be greater than or equal to (DISPATCHER_SERVER_THREAD_COUNT + HTTP_SERVER_THREAD_COUNT + WS_SERVER_THREAD_COUNT + MULTICAST_SERVER_THREAD_COUNT) . The parameter must be greater than or equal to 1 .