cursor insert out of memory error

Last Post 29 Sep 2011 06:27 AM by gunneyk. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Ching
New Member
New Member

--
28 Sep 2011 06:57 PM
use cursor select records from few tables and insert to other table (about 20 columns)at same database, after insert about 800 records it got out of memory error. sql server is 2008 sp1, base OS is windows 2008 R2, 2 notes cluster, each has 16 CPU and 96 GB memory. I'm wondering this is normal or something wrong, like memory configuration issue,anyone comment and suggestion will be appreciated. thanks in advance!
rm
New Member
New Member

--
29 Sep 2011 04:43 AM
How much memory allocated to sql?
gunneyk
New Member
New Member

--
29 Sep 2011 06:27 AM
Are both instances running on the same node by any chance? What type of cursor are you using? Try a STATIC cursor instead.


Acceptable Use Policy
---