cursor insert out of memory error

Last Post 29 Sep 2011 07:27 AM by gunneyk. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Ching
New Member
New Member

--
28 Sep 2011 07: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 05:43 AM
How much memory allocated to sql?
gunneyk
New Member
New Member

--
29 Sep 2011 07: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.
You are not authorized to post a reply.

Acceptable Use Policy