Configure the SAS® Stored Process Server to execute only one request at a time on each MultiBridge server connection


The SAS Stored Process Server, by default, is configured to allow each MultiBridge Stored Process Server process to execute multiple requests at the same time. However, if you are using the SAS® Scalable Performance Data Engine (SPD Engine) or the SPDS engine in a LIBNAME statement in your stored process code, it is helpful to configure the SAS Stored Process Server so that each MultiBridge Stored Process Server executes only one request at a time.

Complete these steps to modify the Load Balancing settings for your SAS Stored Process Server:

  1. Using SAS® Management Console, under Server Manager, select your Logical Stored Process Server.
  2. On the Load Balancing tab of the Properties window, specify these values:

Balancing algorithm: Cost

Cost per client: 99

  1. Select SASApp - Stored Process Server ► Properties ► Options (tab) ► Advanced Options (button) ► Load Balancing (tab).
  2. On the Load Balancing tab of the Advanced Options window, specify this value:

Maximum Cost: 99

Note that the Cost per client value (99) is the same as the Maximum Cost value (99). These values must be the same.

  1. Restart your Object Spawner to activate the change.

Add More MultiBridge Stored Process Server Ports

Because you modified the Load Balancing settings to configure each MultiBridge Stored Process Server to execute only one request at a time (instead of up to five requests), you might need to add more MultiBridge Stored Process Server ports if your workload is heavy. See the Determine the Number of Requests Running on Your SAS Stored Process Server section below to help assess your workload.

Complete these steps to add more MultiBridge Ports:

  1. Using SAS Management Console, select your SAS Stored Process Server under Server Manager.
    For example, select SASApp - Stored Process Server.
  2. In the right window pane, right-click the Bridge connection and select Properties ► Options (tab).

On the Options tab, note the Port numbers that are listed in the MultiBridge port list. These are the port numbers that are currently being used,
and each port number is associated with a single MultiBridge Stored Process Server connection.

Note: If you are using the default configuration, you see these three ports: 8611, 8621, and 8631.

  1. To add more MultiBridge ports, click the Add button and add more ports.

For example, if you want to add three more ports, you might want to add: 8641, 8651, and 8661.
Note: Be sure to specify port numbers that are not being used by another application.

  1. Restart your Object Spawner to activate the change.

Determine the Number of Requests Running on Your SAS Stored Process Server

Complete the calculation below to determine the number of requests that are simultaneously running on your SAS Stored Process Server.

  1. In the SAS Stored Process Server log file, check the Context Cost values.
  2. Divide the Context Cost by 100 to determine the number of requests that were running at a given time.
    For example, if the Context Cost value is 100, then only one request was running at that time. Or, if the Context Cost value is 200, then two requests were running at that time.