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.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.