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.
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.
@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.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.