SPDS performance issue

vivinkumar — Wed, 12 Aug 2020 21:03:27 GMT

Hello,

I tried to initialize/configure SAS Environment Manager - Report Center using this reference document (Chapter 8 and 9) , APM and ACM ETL process - https://go.documentation.sas.com/api/docsets/evug/2.5/content/evug.pdf

Every thing goes well, after this process initialized CPU utilization goes high. Before initialization average CPU usage was ~10%. Now it is ~50%.

I have noticed mostly it is used by SPDSBASE approximately ~800% of CPU usage and it continue for ~5 minutes. Previously it goes to ~800% but for very few seconds.

I have attached the sample performance screenshot.

Followed this document, I have disabled APM and ACM process, but still CPU average usage is ~50%

https://documentation.sas.com/?cdcId=evcdc&cdcVersion=2.5_M1&docsetId=evug&docsetTarget=n112s1uyk72m2wn1cnfksbl03ots.htm&locale=en

Do we have any solution to overcome this issue?

Does restoring the metadata server back (before this initialization) resolve this issue?

I am using SAS 9.4M5 installed in Linux environment.

SPDS 5.4

Thanks in advance!

topic SPDS performance issue in Administration and Deployment

SPDS performance issue