BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
BeNur
Obsidian | Level 7
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) ?
1 ACCEPTED SOLUTION

Accepted Solutions
Meera_SAS
SAS Employee

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

 

Thanks

Meera 

 

View solution in original post

4 REPLIES 4
alexal
SAS Employee

@BeNur,


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

Meera_SAS
SAS Employee

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

 

Thanks

Meera 

 

BeNur
Obsidian | Level 7

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

SASKiwi
PROC Star

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.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 3243 views
  • 6 likes
  • 4 in conversation