BookmarkSubscribeRSS Feed
Fluorite | Level 6


We have several reports on the SAS portal which replaced a .net system. So these reports are very dynamic HTML heavy and run on stored processes.

Currently, I have 5 connection (the 3 original plus 2 more I added). I had to add 2 more because users were timing out waiting on a server.

This has help but I expect more users to come.

My question is regarding the number of connections I can add. How many is too many?

Rhodochrosite | Level 12


Given that each multi-bridge connection, when the Stored Process Server is fully loaded, will result in a SAS process I think it boils down to how many SAS stored process server processes is appropriate for your expected load, your expected response time, and what your hardware can handle, giving consideration to what with other processes may also need to run on that machine (or set of machines).  There are a variety of tuning parameters that can be used to control load balanced servers and you also have the option to scale out with a load balanced cluster of multiple machines if necessary.  You can read more about it in the Overview of Load Balancing section in the SAS 9.3 Intelligence Platform: Application Server Administration Guide.

In your instance, 5 connections does not sound like too many (however I don't know the specs for your hardware and don't know what those stored processes are doing). There is an interesting discussion of stored process server load balancing and tuning parameters in SAS Usage Note 40567: Troubleshooting and tuning the SAS® Stored Process Server and SAS Pooled Works... Whilst this usage note relates to a SAS Marketing Automation situation, it does mention "... At least 9 is recommended ..." and "... if you have defined 40 Multibridge Stored Process Server connections..." so this might give you some examples of the numbers that have been used by others.

You could also try to set up a test environment, with a variety of multi-bridge connections and tuning parameters, run a simulated load of expected stored processes and find the sweet spot for response times. In the past I have used Apache JMeter as software to generate a simulated concurrent client load for a SAS Stored Process Server.

I hope this helps.



Calcite | Level 5

hi Jenny ,

can you share your experience of adding multiple connections , as in my environment i want to increase from  9 to 30 connection to my store process server .And i had good system configuration .

Thanks & Regards,


Barite | Level 11

It is recommended in this 2012 paper (Qing Ye, Richard Nardin, Romon Williams) to have up to 5 Multibridge connections (ports) per CPU core -


Each Multibridge connection can handle up to 5 concurrent client requests, but you can configure it to process just one -


I guess a lot also depends on how 'heavy' you expect those sessions to be.  If your dynamic html is being generated directly with SAS, you might consider alternative approaches, such as serving HTML / javascript directly from the web server and only calling SAS when data is needed.  The Boemska Data Adaptor is great for this, and it's use explained in more detail here -

SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)

Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 4 in conversation