Our ODX is hosted on a separate VM in Azure. We followed the suggestion to use the size DS2_v2, but we encountered frequent “System Out of Memory exception was thrown” errors that caused the ODX to stop.
We are planning to switch to E2_ads_v5, which has twice the memory, but I am curious if anyone else has faced this issue and has any advice.
Hi
Are you using Azure Data Lake storage?
If so, you can use the ‘Limit memory usage when copying data to the data warehouse’ option, see article.
https://support.timextender.com/configure%2Dresources%2D126/use%2Dazure%2Ddata%2Dlake%2Dstorage%2Dfor%2Dyour%2Dodx%2Dinstance%2D800
Another option can be to use Azure Data Factory for copying data from Azure Data Lake to the Data Warehouse layer.
Thanks
Hi
You can also create a monitor metric within Azure VM to see if your VM maxes out on CPU and RAM.
See below,
Pin any of the metrics to a dashboard so you can track if you need to upgrade the VM size or anything else.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
