We moved from SDL 2013 SP1 to SDL Web 8.5 and we are using In Process API.
We have 40+ Applications hosted on 8 servers.
When we did load test for 7000 concurrent users, CPU maxed out.
When I change the connection pool size to 10 the CPU usage reduced to 80%.
We have 2 Database server configured on High Availability Group and each has 32GB RAM.
Is it advisable to increase connection pool size further?
<Storage Type="persistence" Id="sqlserver" dialect="MSSQL" Class="com.tridion.storage.persistence.JPADAOFactory">
<Pool Type="jdbc" Size="5" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" />
<DataSource Class="com.microsoft.sqlserver.jdbc.SQLServerDataSource">
<Property Name="serverName" Value="localhost" />
<Property Name="portNumber" Value="1433" />
<Property Name="databaseName" Value="Tridion_Broker" />
<Property Name="user" Value="TridionBrokerUser" />
<Property Name="password" Value="tridion" />
</DataSource>
</Storage>