SQL Server 2005'内存不足以运行查询' [英] SQL Server 2005 'Insufficient Memory to run the query'
问题描述
我们正在运行由tablediff.exe使用SQLCMD创建的.sql脚本
脚本执行失败并显示''701：没有足够的系统内存来运行此查询。 ''例外。
以下是SQL Server配置
*操作系统：Windows Server 2003
*数据库：SQL Server 2005标准版SP2
*主内存：4GB
*虚拟内存：6GB
*处理器： 2个（Intel XEON 1.6 GHz）
因为我们正在从登台数据库复制数据库，所以我们正在使用tablediff.exe。
由tablediff创建的脚本文件最大大小为30MB。
以下是我们现在使用的SQL Server设置，
*最小服务器内存：0
*最大服务器内存：2147483647
*每个查询最小内存：2048
* AWE启用：否
关于问题在哪里的任何想法？
We are Running a .sql script which was created by tablediff.exe using SQLCMD
The script execution fails with the '' 701: There is insufficient system memory to run this query. '' Exception.
The following was the SQL Server Configuration
* Operating System: Windows Server 2003
* Database : SQL Server 2005 Standard Edition SP2
* Main Memory: 4GB
* Virtual Memory: 6GB
* Processors: 2 nos (Intel XEON 1.6 GHz)
Since, we are replicating a Database from a staging database, we are using the tablediff.exe.
The Script file which was created by the tablediff will be at the maximum size of 30MB.
The following are the SQL Server Settings which we are using now,
* Min Server Memory: 0
* Max Server Memory: 2147483647
* Min Memory Per Query: 2048
* AWE Enabled: No
Any ideas on where is the issue ?
推荐答案
这个错误通常不是一个大小。
通常是在服务器上尝试在无限循环中做某事。
如果你有一个运行的脚本，请尝试注释掉这个脚本的部分内容，找出哪个部分不起作用。
祝您好运。
This error usually is not about a size.
It is usually when server is trying to do something in infinite loop.
If you have a script that you run try commenting out parts of this script and find out which part is not working.
Good Luck.
同步脚本由TableDiff实用程序创建。如果该脚本中的记录数低于20,000，则没有问题。但它失败了，如60,000。我认为没有办法进行无限循环运行。
The sync script was created by the TableDiff utility. If the record count in that script is below 20,000, then no problems there. But it fails on huge counts like 60,000. I don''t think that there will be a way for infinite loop run.
http://support.microsoft.com/kb/912439
http://support.microsoft.com/kb/912439
这篇关于SQL Server 2005'内存不足以运行查询'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
