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.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.