max_connections is used to set the maximum number of connections allowed for SQL Engine. When the number of concurrent connections on the server exceeds the value of max_connections, the server will reject new connection requests.max_connections parameter, you need to consider the following factors:max_connections can be appropriately increased to improve the system's concurrent processing capacity. In the case of resource shortage, the value of max_connections needs to be reduced to avoid resource exhaustion.max_connections may need to be increased to meet concurrent requirements. For low-concurrency applications, the value of max_connections can be reduced to save system resources.max_connections may need to be increased to improve their concurrency processing capability. For databases with poor performance, the value of max_connections needs to be reduced to avoid database overload.Required | Description |
Parameter Type | ULONG |
Default Value | 151 |
Value Range | 1 ~ 100000 |
Effective Scope | GLOBAL |
Restart Required | No |
フィードバック