DWU400的内存错误问题 [英] Memory Error Issue on DWU400

问题描述

我们看到许多错误，指出资源池'SloDWPool'中的系统内存不足，无法运行此查询".当我们运行工作负载(插入，选择等)时.它似乎在最近几天以及之后开始发生 从此处运行内存使用情况查询:

We're seeing a lot of errors stating "There is insufficient system memory in resource pool 'SloDWPool' to run this query" when we're running workloads (Inserts, Selects etc).  It seems to have started happening in the last few days and after running a memory usage query from here:

https://docs.microsoft.com/zh-cn/azure/sql-data-warehouse/analyze-your-workload

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/analyze-your-workload

我可以看到所有4个计算节点的内存利用率均为99％.

I can see that the memory utilisation percentage is 99% for all the 4 compute nodes.

我想知道为查询分配内存资源是否存在问题?

I'm wondering whether there is an issue with queries being allocated memory resources?

任何帮助表示赞赏

谢谢

安迪

推荐答案

安迪，

最近部署了一个错误，此错误已被回滚.如果您仍然遇到此问题，请提交一张说明您的经历的票证，以便我们获得工程师的帮助.

There was a recent bug that was deployed and has since been rolled back. If you are still experiencing this issue, can you please submit a ticket explaining your experience so we can have an engineer help.

最好

Ellis Hiroki

Ellis Hiroki 

这篇关于DWU400的内存错误问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！