SAS EG 8.3 (9.04.01M7) slow performance

[vallsas]

Hi,

My enterprise guide 8.3 (64 bit)is very slow while browsing the table and some times appear  blank screen while drilling down the rows and then appear the data.

sometimes i get error : At least one of the IDs values (element 0 which is o) is invalid

I really need tuning of EG basi performance please any advice/suggestions ..

[Kurt_Bremser]

As a first step, look at your network connection. Latencies are very bad for EG.

[ChrisHemedinger]

The error sounds like a bug - make sure you are running the latest version and if you continue to get the error, work with SAS Technical Support to resolve.

Latency can be an issue. It all depends where SAS Enterprise Guide is running in relation to your SAS environment. The type of data you're browsing can also be a factor. Is it SAS data sets? A database library? A sequential source like Excel or JSON?

Bottom line is it should not be slow in general. Data size usually doesn't matter, but very wide data (hundreds of variables) can be slow because EG must read all fields in a given record, though it pages through the records themselves and doesn't load the entire table into memory.

[SASKiwi]

Does your performance vary throughout the day? Is it faster outside normal business hours? If so then this is likely a network performance issue. Are you using VPN - this can slow EG performance a lot.

EDIT: I'm assuming you are using a remote SAS server here. Please advise if this is not the case. 

[vallsas]

Hi All,

Yes, the same performance is after business hours, not using vpn direct workplace(not wfh) and even not sas remote server.

on premises.

I have question on the attached file why memory uses showing too large?without opening any thing just opened the eg session and then Help -> About sas eg then the config file.

EG config

[Kurt_Bremser]

230M is really not that much for a .NET application with lots of GUI elements.

Run ping and traceroute from your PC to the SAS compute server to see how many network hops the signal takes, and how long it takes to get there and back.

[vallsas]

i used on tracert servername  then following appear

Tracing route to servername 

over a maximum of 30 hopes

1  <1ms    <1ms      <1ms   x.x.x.x

2   1ms    1ms      1ms   x.x.x.x

3   2ms    1ms      1ms   x.x.x.x

4   1ms    1ms      1ms   x.x.x.x

5   1ms    1ms      1ms   x.x.x.x

6   2ms    2ms      1ms   x.x.x.x

7   1ms    1ms      1ms   x.x.x.x

8   1ms    1ms      1ms   x.x.x.x

9   1ms    1ms      1ms   x.x.x.x

10  1ms   1ms      1ms   x.x.x.x

11   1ms  1ms      1ms   x.x.x.x

12  1ms  1ms      1ms   servername 

Trace complete.

[Kurt_Bremser]

So there's quite a lot of stations before the "train" reaches its destination.

Run a ping to the SAS server with continuous repeats in a separate cmd window, and watch how the ping behaves when you open a dataset in EG.

[vallsas]

same 12 iterations coming everytime can we reduce these (stations) iterations by doing some config or do we have any thing workaround?

[Kurt_Bremser]

---

@vallsas wrote:

same 12 iterations coming everytime can we reduce these (stations) iterations by doing some config or do we have any thing workaround?

---

No. If the overall ping time does not change (significantly), then I don't think the network is the culprit here.

(in similar cases, the pings in my home office increased to 200ms +, which slowed down everything)

I can only advise you to open a track at SAS Technical Support, they can help you with setting extended logging of Enterprise Guide itself to detect where the delays originate.

[SASKiwi]

Are there other EG users in your office and do they experience the same slow performance? If they do then the problem is not your PC.

[vallsas]

yes, another user also same problem. 

[ChrisHemedinger]

This may not be the fix but there have been several updates for SAS EG 8.3 since your version. Current is:

 8.3 Update 5 (8.3.5.193)

If permitted, try Help->Check for Updates. Your local admin might have disabled this though as part of IT governance.

[vallsas]

Hi Thank you

where can i see the latest version of sas eg and viya(va) other products so that we can try to get latest version which covers

hot-fixes.

thanks

[ChrisHemedinger]

Hot fix announcements and the issues they address are documented in bulletins here:

https://communities.sas.com/t5/SAS-Hot-Fix-Announcements/bg-p/hf

You can filter the list by product to make potential fixes easier to find. See also this note just for EG.