There is insufficient system memory to run this query.

Last Post 23 May 2006 03:26 PM by nosepicker. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
SQL_Jr
New Member
New Member

--
23 May 2006 11:55 AM
hi, I generated a script using REDGATE, that generated about 400,000 lines of DELETE and INSERT statements. The kicker is that its contained in one BEGIN TRANSACTION....COMMIT TRANSACTION statement. I understand its meant to be all or none. Suffice to say when I ran it, I received the following error:
701 There is insufficient system memory to run this query.

Memory is 1GB, dynamic, sp3a <-- looks good.

Any ideas why the error? How to resolve?
nosepicker
New Member
New Member

--
23 May 2006 12:05 PM
1 GB? Doesn't look good to me, if you want to execute that many statements.
SQL_Jr
New Member
New Member

--
23 May 2006 12:54 PM
Actually, I meant to put a "?" after that statement.

So, given the current memory, is there anything to do (besides adding more memory) to the box to make it run??

Thx.again
nosepicker
New Member
New Member

--
23 May 2006 03:26 PM
Use multiple transactions and put smaller number of statements into them.
SQL_Jr
New Member
New Member

--
24 May 2006 05:59 AM
I found out there were two other instances on the box competing for resources, and were runing parallel processes. Once resources were complete, the script ran completely. We also doubled the virual page file and this helped too. Sheez 1GB and 3 instances w/dynamic memory! You couldn't even fix a decent amout of RAM for each.


Acceptable Use Policy
---