SQL Database Connections for Web Reporter

Document ID : KB000051455
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

CA SRM Web Reporter uses a certain number of SQL connections out of which some are fixed and rest are temporary connections.

Solution:

Web Reporter Server:

  1. Web Reporter Control Panel (WRCP): This component uses one SQL connection to the SQL Central database when it is up and running.

  2. 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.

Example:

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)