SQL Database Connections for Web Reporter

Products

• STORAGE RESOURCE MANAGEMENT SUITE

Issue/Introduction

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

Resolution

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)