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

3. Select SASApp - Stored Process Server ► Properties ► Options (tab) ► Advanced Options (button) ► Load Balancing (tab).
4. 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.

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

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

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

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS Integration Technologies	z/OS	9.3 TS1M1
		Microsoft® Windows® for x64	9.3 TS1M1
		Microsoft Windows Server 2003 Datacenter Edition	9.3 TS1M1
		Microsoft Windows Server 2003 Enterprise Edition	9.3 TS1M1
		Microsoft Windows Server 2003 Standard Edition	9.3 TS1M1
		Microsoft Windows Server 2003 for x64	9.3 TS1M1
		Microsoft Windows Server 2008	9.3 TS1M1
		Microsoft Windows Server 2008 R2	9.3 TS1M1
		Microsoft Windows Server 2008 for x64	9.3 TS1M1
		Microsoft Windows XP Professional	9.3 TS1M1
		Windows 7 Enterprise 32 bit	9.3 TS1M1
		Windows 7 Enterprise x64	9.3 TS1M1
		Windows 7 Home Premium 32 bit	9.3 TS1M1
		Windows 7 Home Premium x64	9.3 TS1M1
		Windows 7 Professional 32 bit	9.3 TS1M1
		Windows 7 Professional x64	9.3 TS1M1
		Windows 7 Ultimate 32 bit	9.3 TS1M1
		Windows 7 Ultimate x64	9.3 TS1M1
		Windows Vista	9.3 TS1M1
		Windows Vista for x64	9.3 TS1M1
		64-bit Enabled AIX	9.3 TS1M1
		64-bit Enabled HP-UX	9.3 TS1M1
		64-bit Enabled Solaris	9.3 TS1M1
		HP-UX IPF	9.3 TS1M1
		Linux	9.3 TS1M1
		Linux for x64	9.3 TS1M1
		Solaris for x64	9.3 TS1M1

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

In some cases, it is helpful to configure the Stored Process server so that each MultiBridge Stored Process Server processes only one request at a time. To accomplish this, you must change the Load Balancing settings.

Type:	Usage Note
Priority:

Date Modified:	2015-12-22 11:02:04
Date Created:	2015-12-02 16:36:33