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

Reply
Occasional Contributor
Posts: 12

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

[ Edited ]

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 

Super User
Posts: 3,918

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

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?

Occasional Contributor
Posts: 12

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

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  

SAS Employee
Posts: 524

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

@ROY30426,

 

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

SAS Employee
Posts: 524

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

SAS Employee
Posts: 16

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

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
Occasional Contributor
Posts: 12

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

[ Edited ]
Posted in reply to Mickey_SAS

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

Occasional Contributor
Posts: 17

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

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?

Occasional Contributor
Posts: 12

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

Posted in reply to daithi1990

Hi @daithi1990,

Could you tell me the log location you mentioned?

Thanks!

Roy

Occasional Contributor
Posts: 17

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

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

Ask a Question
Discussion stats
  • 9 replies
  • 479 views
  • 0 likes
  • 5 in conversation