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

[Kalind_Patel]

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.

[JuanS_OCS]

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/

[ballardw]

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.

[angian]

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.

[Kalind_Patel · Accepted solution]

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 🙂

[ShelleySessoms]

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