How to ensure how many stored process calls from single user gets executed in parallel on STP server

neha11_ch — Thu, 10 Feb 2022 18:09:25 GMT

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?

Re: How to ensure how many stored process calls from single user gets executed in parallel on STP se

AMSAS — Thu, 10 Feb 2022 18:52:00 GMT

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.

topic Re: How to ensure how many stored process calls from single user gets executed in parallel on STP se in SAS Programming

How to ensure how many stored process calls from single user gets executed in parallel on STP server

Re: How to ensure how many stored process calls from single user gets executed in parallel on STP se