topic Re: SAS Viya Visual Analytics report working slow in SAS Visual Analytics

SAS Viya Visual Analytics report working slow

BeNur — Thu, 06 Sep 2018 21:17:31 GMT

Hi all,

SAS Viya 3.3

SAS VA 8.2

Browser - GoogleChrome v.68.0

We have a performance issue with one of the reports in SAS VA in Viya

Report contains :

one data source table - 18GB . This table was loaded to CAS server

5 aggregated functions/measures -without aggregate functions report working faster less than 10 seconds

It takes more than 30 seconds to load reports measures and graphics, should be faster

Can somebody help understand which logs or configuration in Viya should I look through to understand why aggregate functions work so slow ( I suppose all calculation performs in CAS server) ?

Re: SAS Viya Visual Analytics report working slow

alexal — Fri, 07 Sep 2018 12:02:30 GMT

@BeNur,

There are many factors that could potentially affect the performance. I would suggest you open a track with our BI team.

Re: SAS Viya Visual Analytics report working slow

Meera_SAS — Fri, 07 Sep 2018 13:04:11 GMT

Hello @BeNur

In addition to what alexal suggested, please do refer to the following article to gain some insights on where the bottlenecks could be.

https://communities.sas.com/t5/SAS-Communities-Library/Debugging-SAS-Visual-Analytics-Report-Performance-Problems/ta-p/472235

Thanks

Meera

Re: SAS Viya Visual Analytics report working slow

BeNur — Fri, 07 Sep 2018 20:33:34 GMT

Hi @Meera_SAS thank you for the link to the article. It's very usefull

Re: SAS Viya Visual Analytics report working slow

SASKiwi — Fri, 07 Sep 2018 23:32:04 GMT

Your description suggests that report performance without the 5 aggregated measures is OK. What about other VA reports? Are they performing acceptably? If you have only one report with poor performance then that suggests the problem is with this report and not with your VA server performance in general.

On the other hand if you are seeing slow performance in other reports, occasionally or more frequently, then a VA server performance tuning exercise may be worthwhile. We had issues like this earlier this year and optimising JVM settings solved the problem. As already advised, this is best done via a track with SAS Tech Support.