In our SAS environment, SAS Stored process server has 9 multibridge connection. Maximum cost=500
session cost=1, context cost =100, cost per client=1
Hence according to theory, 4 requests can execute on one multibridge connection simultaneously.
So total of (9*4=36) requests should execute in parallel on the SAS Stored process server.
But when I open 12 tabs in a browser and hit one SAS stored process URL at the same time(with a very time gap of miliiseconds), what i observe is that, only 6 requests get executed at a time. and when 6 request completes its execution then next 6 requests gets executed.
In the STP log, it is observed that all 12 requests are being submitted only on 6 multibridge connections port.
So my question is, why not all 12 request to SAS Stored process from a single user are not executed at the same time on SAS STP server?
If you don't get a response then I recommend opening a TS track for this question.
Please include the following:
- SAS Version you are running (the following code will report SAS version information)
%put &sysvlong ;
%put &sysscpl ;
%put &syssite ;
- Registry Report (*.txt files) for each server, please clearly name the report files to reflect the server it was executed on.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.