Parameter: SQLHELPER_CONNECTION_COUNT
Definition
Description
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 SE 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 SE recommends that you reduce the number of threads for the least used services.
Detailed Information
| Name | SQLHELPER_CONNECTION_COUNT
|
|||||||||||||
| 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 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 system or in multiple instances. |
|||||||||||||
| Group(s) | Tuning: Multithreading and Concurrency, Database Management Settings | |||||||||||||
| System Instances | This system parameter is available in the following types of instances in a running SAP CC system: rater, updater, guider, bulkloader, taxer, dispatcher | |||||||||||||
| Default Values (Factory Settings) |
|
|||||||||||||
| Constraint(s) |
The SAP CC system checks the following constraints:
|
|||||||||||||