+1
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.
Best answer by bas.hopstaken
View original
+4
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.
+1
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.
