Attribute

MaxConnectionsPerServer (mcps)

Purpose

Specifies the number of connections that can be granted to a SQL engine server before the Broker creates another server. This option can be tuned to balance performance versus memory consumption. You can improve performance by limiting the number of connections handled by a single server; however, this is done at the expense of allocating more memory for additional servers.

This option is used when the SQL Engine is operating in Broker mode.

Valid Values

max_connections

where:

max_connections

is the maximum number of connections that can be granted to a server before another server is created. This can be a value from 2 to 1024.

Notes

  • This option is used when SQL Engine Mode (SQLEngineMode) is set to 3 (Broker).

Default Value

1024