Is there a mechanism to limit the number of database connections that WCC creates? Currently it appears that it opens 40 database connections even when idle.
On Unix, in $CA_WCC_INSTALL_LOCATION/data/config/application/config/resource/connection.properties, find the following parameters and make appropriate adjustment:
Save the change and restart WCC services.
On Windows, the connection.properties file can be located under %CA_WCC_INSTALL_LOCATION%\data\config\application\config\resource.
The *.database.initialSize parameters set the number of database connections that WCC can create when starting up. The *.database.maxActive parameters set the maximum number of database connections that the WCC server can establish at any time.