Architecting, installing and maintaining your SAS environment

Limit resources per User/Session

Reply
New Contributor
Posts: 3

Limit resources per User/Session

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é 

New Contributor
Posts: 3

Re: Limit resources per User/Session

Using Visual Analitics 9.4
Trusted Advisor
Posts: 1,141

Re: Limit resources per User/Session

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.

New Contributor
Posts: 3

Re: Limit resources per User/Session

Hello,

 

Sorry, i'm using Redhat Linux 6.7.

 

Thanks for the suggestion.

 

Best Regards,

Trusted Advisor
Posts: 1,141

Re: Limit resources per User/Session

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

Ask a Question
Discussion stats
  • 5 replies
  • 475 views
  • 0 likes
  • 2 in conversation