Specifying default connection, load balance, and timeout settings

You can specify default connection, load balance, pool size, and timeout settings for all connections to Intelligence Servers. These default settings can be changed for an individual server in the Server Properties page.

Certain settings can be specified only at this default Intelligence Server level that applies to all server connections. For example, timeout settings cannot be applied to specific Intelligence Server connections, but can be specified to all Intelligence Server connections.

To specify default connection, load balance, and timeout settings

  1. Access the MicroStrategy Web Administrator page. ( How?)

  2. From the pane on the left, select Default properties. The Default Server Properties page opens.

  3. Select one of the following to determine when and how MicroStrategy Web connects to Intelligence Servers.

  4. Specify the Port number for all Intelligence Server connections.

  5. If the Intelligence Servers are in a cluster, you can determine the number of connections within the "pool" of connections. The "pool" is the number of connections between MicroStrategy Web and the Intelligence Servers. This is defined at the Intelligence Server level, not at the cluster level. This allows you to grant more or fewer initial connections depending on the size of the Intelligence Server machines.

  6. Specify how jobs are balanced between Intelligence Servers in a cluster by entering a value in the Load balance factor field. For more powerful servers in a cluster, this value can be increased to provide an appropriate balance. A larger load balance factor means the server supports a greater load in the server cluster in which it resides. For example, if two servers make up a cluster, one server with a balance factor of 3 and the other with a balance factor of 2, and 20 users log in, 12 are supported by the first server and 8 by the second. The default Load balance factor value is 1.

  7. Establish server and request timeout settings, as follows:

  8. If there is a firewall between the Web server and the Intelligence Server, you can ensure that the firewall does not remove connections between the Web server and Intelligence Servers. To do this, select the Keep the connection alive between the Web server and Intelligence Server check box. When this setting is enabled, the MicroStrategy Web server sends a signal to the Intelligence Server on each open TCP connection periodically, so that the firewall does not see the connection as idle. For detailed information, see Maintaining connections through firewalls.

  9. You can also do the following from the Default Server Properties dialog box:

  10. Click Save.