03-11-2016 10:45 AM
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.
03-11-2016 10:54 AM
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.
03-11-2016 11:19 AM
About operating system resources, ultimit is most probably your friend.
But be careful to not intefiere with the pre-requisites of SAS VA to work, there are some important settings to not be modified: