SAS report on Viya perform very slow after migrate from SAS Visual Analytics 7.1 to 8.2

[ROY30426]

Hi Experts,

Recently I'm helping my customer to migrate report from VA7.1 to Viya. Although the report and data was migrated successfully, but some tabs in the report would stuck for at least 5 minutes when click to open . We all know that VA on Viya using html5 ,and hoping it will get better performance than va7.x. Does anyone have the experience for tuning va on viya performance?

Many Thanks!

Roy 

[SASKiwi]

What browser are you using? There are reports that Internet Explorer is slow with HTML5 due to memory limitations. If you are using IE, try Chrome or Firefox. Is it still slow?

[ROY30426]

Hi SASKiwi,

Thanks for your reply. Yes, We have tried Chrome and Firefox, It still perform slowly. We foind that there are many tabs in our customer reports, not sure if its the root cause of the issue.It's really wired that the same report in va7.1 perform smoothly. Is there any configuration we can do for the better performance?

Thnaks!

Roy  

[alexal]

@ROY30426,

Have you noticed any differences in performance between IE and Chrome/Firefox?

[alexal]

@ROY30426,

Also, please read this:

SAS Usage Note 60514: Memory leaks attributed to Microsoft Internet Explorer 11 might affect perform...

[Mickey_SAS]

I'd also like to mention, that memory can be an issue even in Chrome or Firefox, if you have the 32bit version of those browsers. We discuss this a bit in this SAS note

http://support.sas.com/kb/57/733.html

If you confirm you are seeing the issue in 64 bit Chrome and Firefox, then it might be a good idea to open a track with Technical Support on this. It might be necessary to do some more in depth debugging of the report and the query performance

[ROY30426]

Hi All,

Thanks for all the reply.In this month,we have tried lots of way to resolve the issue and unfortunately the issue is still the same. The report perform very slow on IE/Firefox/Chrome, IE would get the memory leak message and others would crash then sas service would be unavailable. I know the size of dataset and the report design would affect the performance. In this case,there are 20 tabs and 5 dataset is used  in the report. The biggest dataset on CAS is 7GB. After many testing,We found that the size of dataset is the key point.Other report with smaller data size(less than 1GB) would perform smoothly(but still slower than VA). Now we are trying to increase the number of cas cache disk,hoping that increase the I/O would help.We will get back to the community once we get the new update. Any suggestion and ideas would give us the big help!  

Many Thanks,

Roy

[daithi1990]

Have you checked httpd to see if there are any requests which are flooding any microservices? 

Also check the consul log, SAS Visual Analytics Logs, and other SAS logs, to see if anything shows up there?

[ROY30426]

Hi @daithi1990,

Could you tell me the log location you mentioned?

Thanks!

Roy

[daithi1990]

they are generally located on the server i.e. var/logs/sas/viya/.... microservice