Question ODBC Group Max Clients Per Server

[Austin Skrepak]

Is there any rule of thumb on what the max clients per server should be on an ODBC group (SQL Only)?

 

[TomBascom]

5

 

[Austin Skrepak]

Will the system automatically attach each ODBC request to an empty server until they all have one before attaching more than one to a server?

 

[Rob Fitzpatrick]

Will the system automatically attach each ODBC request to an empty server until they all have one before attaching more than one to a server?

That depends on your startup parameter settings, particularly -Mi (minimum clients per server), which is a per-broker setting. If -Mi is left at the default value of 1 then the broker will "round-robin": no server will get a second client until all servers have been spawned and each have one client connected. At that point servers will begin to accumulate additional connections.