topic Re: Change Web Infrastructure Platform Data Server installation location in Administration and Deployment

Change Web Infrastructure Platform Data Server installation location

dcmacedo — Mon, 02 Dec 2019 21:16:08 GMT

My productive environment is SAS 9.4M6 for Linux, it was installed on multi-server: Compute Server, Mid-Tier and Metadata.

The Web Infrastructure Platform Data Server (PostgreSQL) is installed on Compute Server. I wonder if it is possible to "move" it to "Mid-Tier", and know the advantages and disadvantages of this change.

Re: Change Web Infrastructure Platform Data Server installation location

SASKiwi — Mon, 02 Dec 2019 22:35:44 GMT

I suggest you check out the performance of this software on your system in SAS Environment Manager. On our SAS Compute Server it is averaging around 2% CPU usage. If it is similar on your system then I can see no advantage in moving it to the mid-tier server for such a small reduction in CPU.

Re: Change Web Infrastructure Platform Data Server installation location

AnandVyas — Tue, 03 Dec 2019 03:32:29 GMT

Hi @dcmacedo,

You haven't posted the reason why you want do this? Are you facing any issues?

If I remember correctly, in the initial release of 9.4M0 it was on Mid-Tier and was later changed to compute.

However it is recommended to host this server on compute node as it has to started before any other services.

Re: Change Web Infrastructure Platform Data Server installation location

dcmacedo — Tue, 03 Dec 2019 20:16:20 GMT

The goal is to decrease the number of active threads in Compute Server. Because I am having problems with "Load Avarege" on this server.

Re: Change Web Infrastructure Platform Data Server installation location

AnandVyas — Wed, 04 Dec 2019 02:37:01 GMT

Oh, I see. I would suggest you to check if any tuning would help here? There are some recommendations provided by SAS in this link - http://support.sas.com/documentation/cdl/en/appsrvtuning/69859/HTML/default/viewer.htm#p0pj0sciz5c3b2n1o5qp95b6uo5x.htm

Also, if the case is that the server is over utilized than what was initially planned, its better to opt for a resizing excerise to match the server(physical/vm) specs for the current demand/utilization. Hope this helps!

Re: Change Web Infrastructure Platform Data Server installation location

SASKiwi — Wed, 04 Dec 2019 06:30:45 GMT

Would be worth involving Tech Support on this problem as well if you haven't already done so. It is a lot easier to tune rather than reconfigure SAS servers.

Re: Change Web Infrastructure Platform Data Server installation location

dcmacedo — Mon, 09 Dec 2019 18:31:24 GMT

SAS support from my country does not help with "optimization" themes. According to them, if it is not broken, there is no problem.

Re: Change Web Infrastructure Platform Data Server installation location

dcmacedo — Mon, 09 Dec 2019 18:31:33 GMT

Thanks for the suggestion, I will read the indicated document. (SAS® 9.4 Web Applications: Tuning for Performance)

Re: Change Web Infrastructure Platform Data Server installation location

dcmacedo — Mon, 09 Dec 2019 18:34:51 GMT

For the moment I will not perform any action. Thanks everyone for the answers.

Re: Change Web Infrastructure Platform Data Server installation location

SASKiwi — Mon, 09 Dec 2019 21:36:09 GMT

@dcmacedo - IMO that is a very strange attitude. Are you seeing poor performance on your App server not due to resource constraints? If so that should be sufficient reason to investigate causes. Personally I've had very positive experiences with SAS Tech Support regarding performance issues.

If you feel that Tech Support is not addressing your problem sufficiently then I suggest you escalate this to your SAS Account Manager.