topic Re: Help require to set SAS server's configuration parameters in Administration and Deployment

Help require to set SAS server's configuration parameters

Divyesh5192 — Fri, 22 Sep 2017 10:02:55 GMT

Dear All,

In out current implementation, We are having server with RHEL having 256GB RAM.

Could you please suggest me values of below parameters in sasv9_local.cfg to utilize server resources at best.

-memsize
-realmemsize
-sortsize
-sumsize
-cpucount

Thank you in advance. 🙂

Re: Help require to set SAS server's configuration parameters

LinusH — Fri, 22 Sep 2017 12:32:30 GMT

It comes down to how many concurrent SAS sessions you would have, and the approximate memory usage.

You want to avoid having the OS to swap, it's better if SAS does that for SAS sessions.

You can start with conservative numbers, monitor (OS, and SAS logs), and make adjustments as you go.

Re: Help require to set SAS server's configuration parameters

rkbright — Fri, 22 Sep 2017 12:43:17 GMT

Hi Divyesh - What kind of configuration are you running? single? complex multi-teir?

I have a multi-teir configuration currently on RHEL 7.3 in AWS. I didn't set any local parameters in sasv9_local.cfg as I left the default settings at this time. I usually tell folks to create a sasv9.cfg file in their home directory that will override settings for analyses and processes that require more resources.

-NEWS !SASROOT/misc/base/news
-SASUSER ~/sasuser.v94
-WORK /tmp
-MEMSIZE 2G
-SORTSIZE 1G
-WORKPERMS 700

Hope this helps

Thanks,

Richard

Re: Help require to set SAS server's configuration parameters

ronan — Fri, 22 Sep 2017 13:32:40 GMT

See this note for recommended values :

https://support.sas.com/kb/46/954.html

this isn't specific - as every case is (or ought to be) - so tuning up further for your context will take into account

SLA, performance requirements, user needs & expectations etc.

Usually, selecting the number of concurrent sessions and workload profile (light reporting, on demand analytics, batch etc.) as a whole or spliced up into 3-4 categories (light user/middle/heavy user + batch) will do.

With a large RAM size, if you don't expect too many concurrent sessions, then you might have a look at this paper which describes how to optimize RAM occupation for SAS jobs based on their priorities :

https://support.sas.com/resources/papers/proceedings16/11825-2016.pdf

tmpfs virtual filesystem can help a lot.

If you have installed a SAS in-memory product like Visual Analytics then take care to confine each execution context to avoid conflict of resource like RAM...

Re: Help require to set SAS server's configuration parameters

Divyesh5192 — Fri, 22 Sep 2017 15:50:39 GMT

Hi Richard,

Thank you for prompt response.

We are having plarform LSF implemented over cluster having one server node.

And it is two tier actually, database server and sas server are one different physical node.

Re: Help require to set SAS server's configuration parameters

SASKiwi — Fri, 22 Sep 2017 21:54:37 GMT

We've found MEMSIZE of 2G to be a bit low for some of our SAS jobs so we now set it at 3G.

Re: Help require to set SAS server's configuration parameters

nhvdwalt — Sat, 23 Sep 2017 16:14:43 GMT

This gives a nice explanation of the FULLSTIMER option....

http://support.sas.com/rnd/scalability/tools/fullstim/index.html