Desktop productivity for business analysts and programmers

Stopping take too long.

Reply
Occasional Contributor
Posts: 19

Stopping take too long.

Hi, I am using SAS EG 4.3 (4.3.0.10196)

 

Whenever I want to stop the process, the Stopping really take long (more than 1 hour).

 

Could I really stop the process of the SAS query instantly?

 

Thanks

Occasional Contributor
Posts: 19

Re: Stopping take too long.

Is there possibility to do stop with timer or configuration of memory usage?

Respected Advisor
Posts: 3,065

Re: Stopping take too long.

What is your process doing? I find the stop button pretty quick unless it is doing an external database query. In this case it may take a long time for control to return to SAS.

Occasional Contributor
Posts: 19

Re: Stopping take too long.

Yes it is Oracle database

Respected Advisor
Posts: 3,065

Re: Stopping take too long.

In that case I don't think there are any options in EG to make this faster.

 

If you have access to SAS Management Console you can kill your EG server session and start over, but you would probably need to be set up with the Administrator metadata role to do that. 

Trusted Advisor
Posts: 1,059

Re: Stopping take too long.

Keep in mind, even if you do kill the SAS process, most likely the process that retrieves from the database will keep going, and put a load on your database. There's really no good soluion to this problem, except to test your processes with smaller volumes of data until you know they work.

 

Tom

Occasional Contributor
Posts: 17

Re: Stopping take too long.

i normaly disconnect from the server all together.

 

the down side to this is that if you are extracting from the database you will have the process cotinuing in the background.

I then use the below code to kill those processes

 

data _null_;

   x 'kill -9 process_id';

run;

 

to get your process_id there are few unix commands to use to determine what processes are linked to your user profile. unfortunately i am not that good with unix. to make things easy for me, i always ask my administrator if there are any processes running under my name.

 

i normally get a list in the morning of processes that i have executed for more than 12 hours

Ask a Question
Discussion stats
  • 6 replies
  • 514 views
  • 0 likes
  • 4 in conversation