High Memory Usage

[doalpl]

Hi,

We have two VM servers running Alteryx, one is configured as the Controller and the other a Worker. The Worker server is showing very high memory usage, about 80% server memory is being used and roughly 8GB of memory is consistently being used for the AlteryxMetrics.exe process. In comparison, on the Controller server, the AlteryxMetrics.exe process only uses about 300mb and general memory usage is much lower.

The high memory usage remains even when there are no workflows being run on the server. This seems to be causing an issue at busy times for example during the morning, and I have received reports of memory allocation errors when running a workflow at these times.

Is the high memory usage for AlteryxMetrics.exe on a Worker server normal?

Hope you can help, not sure how to proceed aside from requesting the server to be restarted.

Thanks in advance for your help.

[AZuc]

@doalpl , which version are you using?

Could you also check if you can unset "Send Server usage data" on the first screen of Alteryx System Settings?

[doalpl]

Alteryx Server provides a comprehensive and scalable server-based analytics solution that provides end users and business decision makers the ability to share and run analytic applications in a web-based environment. https://192168ll.red/ https://routerlogin.red/ https://19216801.cc/

[NAnnaldasula]

Unchecking the Mapping configuration and Insights configuration in Alteryx system settings and running the following commands should resolve the issue.

1. Connect to the Server MongoDB's AlteryxGallery database using a MongoDB UI such as Robo3T: How to Connect to an Embedded Server UI MongoDB using Robo 3T
2. Run the following command to remove the sessions older than 30 days:

            db.sessions.remove({UpdateDate:{$lt: new Date(ISODate().getTime() - 1000 * 86400 * 30)}})

3. Run the following command to build the index within the AlteryxGallery.sessions collection:

            db.getCollection('sessions').createIndex({SessionId: -1})

Nikhil Annaldasula

Alteryx Admin consultant