topic Re: Services taking 1.5 hour to up in VA 7.2 single machine windows in Administration and Deployment

Services taking 1.5 hour to up in VA 7.2 single machine windows

Kalind_Patel — Fri, 14 Oct 2016 09:09:03 GMT

Hello All,

I'm facing this issue after the last week,

after restarting services, it is taking too much time to up the VA and other web apps,

Is there any parameter in SAS configuatoin files, so i can allocate more memory to start the services,

because it usually take 40-45 minutes to start the services;

Any suggestions would be appreciated,

Thanks.

Re: Services taking 1.5 hour to up in VA 7.2 single machine windows

JuanS_OCS — Fri, 14 Oct 2016 09:50:53 GMT

Hi,

first, I would suggest to give a look on the logs. I understand your problem is only on the SAS Web Application Servers, not on the metadata or compute.

Secondly, I would suggest you to use the SAS Environment Manager, jmeter or even the Java console, to know the status of your Pooled Threads, open Connections and the Java Memory heap size. You might need to extend your memory setings for the java machine (probably on SASServer1_1 only). Give a look into the guide for Tuning for Performance and Scalability of the SAS Web Applications on 9.4: https://support.sas.com/documentation/cdl/en/appsrvtuning/68923/PDF/default/appsrvtuning.pdf

Do you have the Audit reports enabled on VA? Maybe you need to clean/archive/purge the EVM datamart.http://blogs.sas.com/content/sgf/2016/01/26/going-visual-analytics-audit-data-archiving/

Re: Services taking 1.5 hour to up in VA 7.2 single machine windows

ballardw — Fri, 14 Oct 2016 14:55:08 GMT

Another thing to look at when a recurring job suddenly changes behavior, assuming the data load is similar, would be to see what SYSTEM changes may have happened.

You mention "after restarting services". I would look to see if any of the settings affecting those services changed and also if your IT people made any changes that kicked in with the restart. I have come into work and had SAS not work at all because our IT department completely trashed my registry overnight.

Re: Services taking 1.5 hour to up in VA 7.2 single machine windows

angian — Fri, 14 Oct 2016 17:22:56 GMT

Verify that the startStopThreads parameter is set to 0 in SASServerx_1/conf/server.xml

This will use all the cores available on the server. Sometimes this value is set to just 1.

Re: Services taking 1.5 hour to up in VA 7.2 single machine windows

Kalind_Patel — Mon, 07 Nov 2016 07:25:54 GMT

Thanks all for suggestions, We found the issue, Service was taking that much time because Audit_table size was increased (SAS Tech Support gave this reason), They connected to SAS EV Manager Database and after some changes, Again startup time reduced to 40-45 minutes; Thanks all for your help 🙂

Re: Services taking 1.5 hour to up in VA 7.2 single machine windows

ShelleySessoms — Mon, 07 Nov 2016 13:11:40 GMT

Thanks for letting the community know what worked based on tech supports' suggestion. I appreciate the follow up, so it may help others.