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é
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.
Hello,
Sorry, i'm using Redhat Linux 6.7.
Thanks for the suggestion.
Best Regards,
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/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
PS. I would personally set the limits in the application ( LASR server and maybe SASApp) rather than in the operating system
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.