c# - context.Database.ExecuteSqlCommand - 错误代码 701 - Microsoft Azure

Question

我在迁移配置播种方法中有以下代码:

string sqlQuery = // 22 mb file contents
context.Database.ExecuteSqlCommand( sqlQuery );

ExecuteSqlCommand 函数使 Azure 抛出此错误:

The service has encountered an error processing your request. Please try again. Error code 701. A severe error occurred on the current command. The results, if any, should be discarded.

为什么会这样呢？我实在找不到太多相关信息

Answer 1

根据我的谷歌搜索，SQL错误701如下:

SQL Server has failed to allocate sufficient memory to run the query. This can be caused by a variety of reasons including operating system settings, physical memory availability, or memory limits on the current workload. In most cases, the transaction that failed is not the cause of this error.

可能是时候进行升级，或者更改查询要撤回的内容或将其拆分为单独的查询。