我可以为ERROR保留系统内存吗'[SQL Server]资源池'default'中没有足够的系统内存来运行此查询。'？ [英] Can I reserve system memory for an ERROR '[SQL Server]There is insufficient system memory in resource pool 'default' to run this query.' ?

问题描述

我可以为ERROR预留系统内存吗'[SQL Server]资源池'default'中没有足够的系统内存来运行此查询。'？
我想使用'我们系统中的MEMORY_OPTIMIZED = ON' 表。

Can I reserve system memory for an ERROR '[SQL Server]There is insufficient system memory in resource pool 'default' to run this query.' ?
I want to use 'MEMORY_OPTIMIZED = ON' tables in our SYSTEM.

----示例错误

03/22/14 08：18：58.089 [0x00001330] [ spid 148] SQLState：42000，本机错误：701，严重级：17，状态：109，行：49

[SQL Server]资源池"default"中没有足够的系统内存来运行此查询。

---- EXAMPLE ERROR
03/22/14 08:18:58.089 [0x00001330] [spid 148] SQLState: 42000, Native Error: 701, Severity: 17, State: 109, Line: 49
[SQL Server]There is insufficient system memory in resource pool 'default' to run this query.

超过10,000,000行插入到MEMORY_OPTIMIZED = ON表到SQL Server 2014 CTP2。

over 10,000,000 rows insert to MEMORY_OPTIMIZED=ON table to SQL Server 2014 CTP2.

问候

Yoshihiro Kawabata

Regards
Yoshihiro Kawabata

推荐答案

首先，您需要确保为内存中的数据配置足够的内存 - 优化表。以下内容将帮助您确定您的内存需求：

First off, you will need to make sure to provision sufficient memory for the data in your memory-optimized tables. The following will help you determine your memory needs:

http://technet.microsoft.com/en-us/library/dn282389(v = sql.120）.aspx

然后，我们建议将数据库绑定到资源池并设置max_memory_percent以限制内存优化表的内存使用量，以限制OOM条件对服务器上其他工作负载的影响：

Then, we recommend to bind the database to a resource pool and set max_memory_percent to cap the memory usage for memory-optimized tables, to limit the impact of OOM conditions on the other workloads on the server:

http://technet.microsoft.com/en-us/library/dn465873（v = sql.120）.aspx

最后，我们提供了一些监控内存使用情况和排除OOM故障的提示：

Finally, we have some tips on monitoring memory usage and troubleshooting OOM:

http://technet.microsoft.com/en-us/library/dn465869(v=sql .120）.aspx

http://technet.microsoft.com/en-us/library/dn4658 74（v = sql.120）.aspx

谢谢，

Jos de Bruijn [MSFT]

Jos de Bruijn [MSFT]

这篇关于我可以为ERROR保留系统内存吗'[SQL Server]资源池'default'中没有足够的系统内存来运行此查询。'？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！