topic Re: SAS Visual Analytics 7.5 Hub is slow - reports as well in SAS Visual Analytics

SAS Visual Analytics 7.5 Hub is slow - reports as well

Filipvdr — Tue, 27 Oct 2020 08:47:38 GMT

Hello,

We're running a SAS Visual Analytics 7.5 on linux environment since the beginning of 2020.

At the moment the HUB is loading very slowly, and the reports as not as fast anymore. Are there any logs which should be cleaned? What can i check?

Filip

Re: SAS Visual Analytics 7.5 Hub is slow - reports as well

JosvanderVelden — Tue, 27 Oct 2020 10:31:59 GMT

Does the information in this thread help?
https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-Performing-very-slowly/td-p/294713

Best regards, Jos

Re: SAS Visual Analytics 7.5 Hub is slow - reports as well

SASKiwi — Tue, 27 Oct 2020 22:09:33 GMT

Check VA Environment Manager, in particular your SAS VA web server. What is your CPU usage chart doing - are you hitting close to 100% a lot? Are there any alerts about performance?

Re: SAS Visual Analytics 7.5 Hub is slow - reports as well

Filipvdr — Wed, 28 Oct 2020 07:47:55 GMT

Which values should I select? I'm not familiar with using this Metric viewer.

Re: SAS Visual Analytics 7.5 Hub is slow - reports as well

SASKiwi — Wed, 28 Oct 2020 19:17:41 GMT

If there are no resources showing in the Favorite Resources panel of your Dashboard, just do an Auto-Discovery and that should populate all of your resources automatically. When I do that, Favorite Resources lists all of the SAS VA servers, then you just click on your SAS web server link to see all the resources for that including CPU usage.

Re: SAS Visual Analytics 7.5 Hub is slow - reports as well

Filipvdr — Fri, 30 Oct 2020 08:22:15 GMT

Could this be something? Since COVID, we are all working from home, through a VPN.

Is this network related?

Re: SAS Visual Analytics 7.5 Hub is slow - reports as well

SASKiwi — Fri, 30 Oct 2020 22:33:40 GMT

To check if it is VPN-related, remotely connect to a computer inside your company's intranet and test VA performance there. If it is a lot faster then that might explain it. However if VPN is slow then I'd expect everything network-related on your VPN-connected computer to be slow and not just SAS VA: email, reading and saving to remote servers, web browsing etc.

I use VA over VPN and it performs fine as it doesn't produce a lot of network traffic.

Your HTTP chart looks really slow. Our VA HTTP chart averages 74ms - a lot faster than your 2.6s. Slow HTTP could be caused by many different things not just a slow network.

I suggest you raise a track with SAS Tech Support as they are in the best position to help you diagnose your problem.

Re: SAS Visual Analytics 7.5 Hub is slow - reports as well

JuanS_OCS — Sat, 31 Oct 2020 19:53:26 GMT

Hi there,
in addition to the information shared by Jos (thanks), if youhave enabled VA auditing aka the VA administration reports, you might need schedule a periodic clean od the Audit dataon the WIPdatabases

This overhead fills in the JVMs and the final result is an incredibly slow login and applications. To increase to JVMs values help, but it is not the final solution.

Re: SAS Visual Analytics 7.5 Hub is slow - reports as well

Filipvdr — Tue, 03 Nov 2020 09:18:48 GMT

Thanks for your answers, I did raise a track to SAS Support based on the feedback i received here i could give already some extra information

The solution was to clean up the environment: It seems we ran out of cache/memory space.

- Stop the SAS services
- Validate that all the sas services are stopped
- Clean the logs of the web application servers (where <x> refers to the number of the SASServer e.g. SASServer1_1, SASServer2_1, SASServer12_1, SASServer13_1)

* <SASConfig>/Lev1/Web/WebAppServer/SASServer<x>_1/temp/*
* <SASConfig>/Lev1/Web/WebAppServer/SASServer<x>_1/work/Catalina/localhost/*
* <SASConfig>/Lev1/Web/WebAppServer/SASServer<x>_1/logs/

- Clear the cache (https://www.tecmint.com/clear-ram-memory-cache-buffer-and-swap-space-on-linux/)

§   1. Clear PageCache only.
§   # sync; echo 1 > /proc/sys/vm/drop_caches
§   2. Clear dentries and inodes.
§   # sync; echo 2 > /proc/sys/vm/drop_caches
§   3. Clear PageCache, dentries and inodes.
§   # sync; echo 3 > /proc/sys/vm/drop_caches