资源池“默认"中没有足够的系统内存来运行此查询 [英] There is insufficient system memory in resource pool 'default' to run this query

问题描述

我收到此错误:

资源池默认"中没有足够的系统内存来运行此查询.

There is insufficient system memory in resource pool 'default' to run this query.

我仅运行100,000个简单的插入语句，如下所示.我在第85,000个插入处出现错误.

I'm just running 100,000 simple insert statements as shown below. I got the error approx on the 85,000th insert.

这是我正在上课的演示...

This is a demo for a class I'm taking...

use sampleautogrow

INSERT INTO SampleData VALUES ('fazgypvlhl2svnh1t5di','8l8hzn95y5v20nlmoyzpq17v68chfjh9tbj496t4',1)
INSERT INTO SampleData VALUES ('31t7phmjs7rcwi7d3ctg','852wm0l8zvd7k5vuemo16e67ydk9cq6rzp0f0sbs',2)
INSERT INTO SampleData VALUES ('w3dtv4wsm3ho9l3073o1','udn28w25dogxb9ttwyqeieuz6almxg53a1ki72dq',1)
INSERT INTO SampleData VALUES ('23u5uod07zilskyuhd7d','dopw0c76z7h1mu4p1hrfe8d7ei1z2rpwsffvk3pi',3)

在此先感谢您， 吉姆M

Thanks In Advance, Jim M

更新:刚刚发现了一些非常有趣的东西.我创建了另一个数据库，忘记创建SampleData表.我运行查询以添加100,000行，并且在抱怨表不存在之前它遇到了内存不足错误.因此，我猜想它只是试图读"我的100,000行而已用光了内存?

Update: Just noticed something very interesting. I created another database, forgot to create the SampleData table. I ran the query to add the 100,000 rows, and it got the out of memory error before it even complained that the table didn't exist. Thus, I'm guessing it is running out of memory just trying to "read in" my 100,000 lines?

推荐答案

您在一个批处理请求中有100.000个插入语句?您的服务器需要更多的RAM才能解析请求.购买更多的RAM，升级到x64或减小发送到服务器的单个批次的大小. IE.随时在.sql文件中撒上 GO .

You have 100.000 insert statements in one single batch request? Your server needs more RAM just to parse the request. Buy more RAM, upgrade to x64 or reduce the size of single batches sent to the server. Ie. sprinkle a GO every now and there in the .sql file.

这篇关于资源池“默认"中没有足够的系统内存来运行此查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！