CA SRM Web Reporter uses a certain number of SQL connections out of which some are fixed and rest are temporary connections.
Web Reporter Server:
- Web Reporter Control Panel (WRCP): This component uses one SQL connection to the SQL Central database when it is up and running.
- Trend Service: This uses one fixed connection to SQL Central database on Web Reporter Server machine.
SRM Application Server:
Web Reporter Data Bridge (WRDB): Each managed object in SRM make one SQL connection during bulk/delta data upload to Central database and based on the number of managed objects in SRM server, this can reach a maximum of 40 concurrent connections.
Once the data upload is completed, all connections will be closed by the WRDB process.
Business Objects (BO):
BO Universe uses one connection to SQL Central database for InfoView and Central Management Console sessions when BO services are up and running.
If you plan to have 1 Web Reporter Server managing 3 SRM Application Servers, you would need 3 + 40x3 = 123 connections.
(WRCP -1, Trend Service -1, Business Objects -1, WRDB - 40 temporary)