topic Re: EG Running very slow in complete phase in SAS Enterprise Guide

EG Running very slow in complete phase

Toni2 — Mon, 18 Jul 2022 11:19:38 GMT

I use SAS EG 7.15 and i run data from my organisation server. Since last week or so i have found a dramatic increase in time for running the same codes. The odd thing is : when i run a code i can see in the status bar (see below the picture) the different SAS functions to change quickly (for example, data, proc sql etc.). However, when the program comes to the end and moves to the "complete" phase it takes unusual time to complete this phase.

For example, i have a file which is my set up and i use it to load libraries and formats. It used to take less than 10 sec. to run it. However, now it takes 5 min. for the same file and most of the time the status is in the "Complete" phase

Any idea, advise will be welcome

Re: EG Running very slow in complete phase

AlanC — Mon, 18 Jul 2022 11:47:42 GMT

It is most likely a latency issue. See if the server moved to a new location or if you have code that calls a file that is now not local to the job.

The server also may be under load. Disk thrashing can cause wild spikes so the server could be constrained.

There isnt really much in your question to aid in diagnosis. I can give you just some guesses based upon my consulting experiences and common causes. Server or network assuming code hasnt changed.

Re: EG Running very slow in complete phase

andreas_lds — Mon, 18 Jul 2022 12:03:37 GMT

Please contact your local sas admins, they should be able to investigate the problem further.

Re: EG Running very slow in complete phase

Kurt_Bremser — Mon, 18 Jul 2022 12:04:55 GMT

Set your EG to not automatically open resulting datasets and resulting output. And try to keep your logs clean and short, as those are always retrieved completely upon completion of a submit.

Re: EG Running very slow in complete phase

AlanC — Mon, 18 Jul 2022 12:11:17 GMT

Kurt,

Along those lines, I think reviewing the logs may help. Perhaps a large number of errors, warnings, and notes are being generated suddenly causing the log to explode.

Re: EG Running very slow in complete phase

Sajid01 — Sat, 23 Jul 2022 16:29:30 GMT

You can add fullstimer option to the code and check the logs. This will give an idea about the issue.

However this is in all probability due to some change at the infrastructure level. Multiple teams may be involved. Seek the help of the SAS Administrator.