Limit resources per User/Session

[andreffonseca]

Hello everyone,

I've some problems with queries made by users (extremelly bad queries) that are consuming all machine resources and then the server crashes.

It's possible to limit, by default to all session, the maximum memory allocated?

Thanks in Advance.

André 

[andreffonseca]

Using Visual Analitics 9.4

[JuanS_OCS]

Hi Andre,

each operating system has its own options, but probably what you would like is to create a new SASApp or, at least, a new LASR server for thos users. In the LASR server you can set a memory limit, and a new SASApp will allow you to set a complete set of options.

[andreffonseca]

Hello,

Sorry, i'm using Redhat Linux 6.7.

Thanks for the suggestion.

Best Regards,

[JuanS_OCS]

About operating system resources, ultimit is most probably your friend.

http://www.tldp.org/LDP/solrhe/Securing-Optimizing-Linux-RH-Edition-v1.3/chap5sec44.html

http://www.serverwatch.com/server-tutorials/set-user-limits-with-pamlimits-and-limits.conf.html

http://unix.stackexchange.com/questions/8945/how-can-i-increase-open-files-limit-for-all-processes

https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/6/html/Resource_Management_Gu...

https://access.redhat.com/solutions/30316

But be careful to not intefiere with the pre-requisites of SAS VA to work, there are some important settings to not be modified:

https://support.sas.com/resources/thirdpartysupport/v94/appservers/preinstall.html

https://support.sas.com/documentation/cdl/en/appsrvtuning/68923/PDF/default/appsrvtuning.pdf

http://support.sas.com/kb/38/040.html

[JuanS_OCS]

PS. I would personally set the limits in the application ( LASR server and maybe SASApp) rather than in the operating system