topic Parallel Processing in SAS Stored Process servers in Developers

Parallel Processing in SAS Stored Process servers

Sarath — Mon, 05 Jan 2015 08:01:11 GMT

Hello SAS Experts,

I would like to know if its possible to implement parallel processing in SAS Stored process servers. I know and have implemented the same in SAS Workspace servers but I'm not sure of its feisibility in SAS Stored Process servers.

The said build in which I'm thinking of implementing the same generates Excel outputs in the end and the same is meant to be executed from SAS Information Delivery Portal post its release.

Currently it enforces sequential processing of functionally independent modules one after the other which could be done in parallel to save time, but I'm unsure of its possibility in Stored process servers.

Please cionvey your thoughts.

Regards,

Sarath

Re: Parallel Processing in SAS Stored Process servers

Jchapman — Wed, 18 Feb 2015 01:35:14 GMT

Might I ask how you do this with the Logical Workspace server?

James

Re: Parallel Processing in SAS Stored Process servers

FriedEgg — Wed, 18 Feb 2015 01:40:27 GMT

rsubmit

Re: Parallel Processing in SAS Stored Process servers

Kurt_Bremser — Wed, 18 Feb 2015 07:40:05 GMT

When trying this, keep in mind that your HW should be able to to this in a reasonable manner. Starting up the parallel processes will take time and resources, and when those processes compete for resources (CPU cores, RAM, disk access), they may actually slow each other down so that the final result is worse (slower) than simple processing in succession.

A process that runs for 2 minutes and is repeated 10 times takes 20 minutes, but running the 10 processes in parallel may easily take you more than an hour, if your server is not designed for parallel work.