I am trying to trying to run some insert code(about 40,000 of them) using SSMS but I keep running up against SQL out of memory errors among others. I would appreciate any help to fix this problem please.
我试图尝试使用SSMS运行一些插入代码(大约40,000个),但我一直在遇到SQL内存错误等问题。我很感激任何帮助来解决这个问题。
2 个解决方案
#1
3
This exception is a .NET exception, so it cannot come from SQL Server. It comes from SSMS itself. Your machine has not enough ram.
此异常是.NET异常,因此它不能来自SQL Server。它来自SSMS本身。你的机器没有足够的内存。
OutOfMemoryException also has nothing to do with disk space. It refers to RAM.
OutOfMemoryException也与磁盘空间无关。它指的是RAM。
#2
0
After hours of digging, I decided to uninstall all of the Redgate tools that I had been using with my SQL installation. It seems that the problem was being caused by one of these tools.
经过几个小时的挖掘,我决定卸载我在SQL安装中使用的所有Redgate工具。似乎问题是由这些工具之一引起的。
#1
3
This exception is a .NET exception, so it cannot come from SQL Server. It comes from SSMS itself. Your machine has not enough ram.
此异常是.NET异常,因此它不能来自SQL Server。它来自SSMS本身。你的机器没有足够的内存。
OutOfMemoryException also has nothing to do with disk space. It refers to RAM.
OutOfMemoryException也与磁盘空间无关。它指的是RAM。
#2
0
After hours of digging, I decided to uninstall all of the Redgate tools that I had been using with my SQL installation. It seems that the problem was being caused by one of these tools.
经过几个小时的挖掘,我决定卸载我在SQL安装中使用的所有Redgate工具。似乎问题是由这些工具之一引起的。