topic Re: SAS EG 8.3 (9.04.01M7) slow performance in SAS Enterprise Guide

SAS EG 8.3 (9.04.01M7) slow performance

vallsas — Wed, 18 May 2022 10:18:04 GMT

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 ..

Re: SAS EG 8.3 (9.04.01M7) slow performance

Kurt_Bremser — Wed, 18 May 2022 10:40:42 GMT

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

Re: SAS EG 8.3 (9.04.01M7) slow performance

ChrisHemedinger — Wed, 18 May 2022 13:35:34 GMT

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.

Re: SAS EG 8.3 (9.04.01M7) slow performance

SASKiwi — Wed, 18 May 2022 22:18:01 GMT

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.

Re: SAS EG 8.3 (9.04.01M7) slow performance

vallsas — Thu, 19 May 2022 07:37:20 GMT

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

Re: SAS EG 8.3 (9.04.01M7) slow performance

Kurt_Bremser — Thu, 19 May 2022 08:12:28 GMT

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.

Re: SAS EG 8.3 (9.04.01M7) slow performance

vallsas — Thu, 19 May 2022 09:10:11 GMT

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.

Re: SAS EG 8.3 (9.04.01M7) slow performance

Kurt_Bremser — Thu, 19 May 2022 09:17:41 GMT

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.

Re: SAS EG 8.3 (9.04.01M7) slow performance

vallsas — Thu, 19 May 2022 10:48:17 GMT

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

Re: SAS EG 8.3 (9.04.01M7) slow performance

Kurt_Bremser — Thu, 19 May 2022 10:57:05 GMT

@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.

Re: SAS EG 8.3 (9.04.01M7) slow performance

ChrisHemedinger — Thu, 19 May 2022 11:24:48 GMT

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.

Re: SAS EG 8.3 (9.04.01M7) slow performance

SASKiwi — Thu, 19 May 2022 19:58:44 GMT

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.

Re: SAS EG 8.3 (9.04.01M7) slow performance

vallsas — Fri, 20 May 2022 03:51:31 GMT

yes, another user also same problem.

Re: SAS EG 8.3 (9.04.01M7) slow performance

vallsas — Fri, 20 May 2022 04:06:42 GMT

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

Re: SAS EG 8.3 (9.04.01M7) slow performance

ChrisHemedinger — Sat, 21 May 2022 18:35:12 GMT

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.

Re: SAS EG 8.3 (9.04.01M7) slow performance

SASKiwi — Mon, 23 May 2022 00:32:24 GMT

I suggest you open a SAS Tech Support track for this if you haven't done so already. It looks like some more diagnosing of your problem is required and Tech Support is in the best position to progress this.

Re: SAS EG 8.3 (9.04.01M7) slow performance

vallsas — Tue, 24 May 2022 12:19:09 GMT

Okay Thank you! I had experience that Techsupport was not able to clarify, however I will raise TS.

Re: SAS EG 8.3 (9.04.01M7) slow performance

vallsas — Tue, 31 May 2022 04:18:28 GMT

Hi ,

I have raised the tech support about the latest versions but I received the following link:

https://support.sas.com/en/software/all-products-support.html#

which does not show any latest releases..

Re: SAS EG 8.3 (9.04.01M7) slow performance

SASKiwi — Tue, 31 May 2022 04:52:44 GMT

I checked out that link and found this which includes the latest release of EG: SAS Enterprise Guide | SAS Support

Re: SAS EG 8.3 (9.04.01M7) slow performance

vallsas — Tue, 31 May 2022 05:47:07 GMT

The most recent release is SAS Enterprise Guide 8.3.

[ but i am not able to see the 8.3.x.x ( 8.3.1.119 like this]