Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Getting an error "Exception of type 'System.OutOfMemoryException' was thrown." during stored procedure execution Expand / Collapse
Author
Message
Posted Wednesday, April 18, 2012 10:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 2, 2014 10:59 AM
Points: 11, Visits: 76
Figured it out... It was my desktop running the SSMS and executing the query that ran out of memory
Post #1285802
Posted Wednesday, April 18, 2012 10:31 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 10:03 AM
Points: 1,106, Visits: 1,334
well yes that would normally be the cause of 'out of memory', but there are things you can do to prevent that.

Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Post #1285804
Posted Monday, April 23, 2012 9:59 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:05 PM
Points: 1,283, Visits: 2,960
Schadenfreude-Mei (4/18/2012)
well yes that would normally be the cause of 'out of memory', but there are things you can do to prevent that.



I have also seen this ty of behavior when I run fr my local machine....how do you prevent that?
Post #1288633
Posted Tuesday, April 24, 2012 5:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 10:03 AM
Points: 1,106, Visits: 1,334
sqldba_newbie (4/23/2012)
Schadenfreude-Mei (4/18/2012)
well yes that would normally be the cause of 'out of memory', but there are things you can do to prevent that.



I have also seen this ty of behavior when I run fr my local machine....how do you prevent that?


If it is a large query you may want to break it down or copy to temp tables or something. Ultimately though you might have to run it from the server. Its sounds a bit stereotypical but a reboot of your local machine may also help.


Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Post #1288817
Posted Wednesday, April 3, 2013 3:20 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Hi,

I am also facing the same issue in my production database whenever right click database >> Task >> restore >>database.

Server configuration :

32 GB RAM
64 bit O/S
2 processors
Intel(R) Xeon(R) E5620 @2.40GHZ
service pack 2
SQL server 2008R2

I think this is sufficient information about the server.

In that server over all 750 databases which around 60 GB. And log shipping configure around 700 databases.

Error screenshot attached for ref.

Thanks.


Pradeep

  Post Attachments 
Error.docx (5 views, 24.95 KB)
Post #1438224
Posted Thursday, April 4, 2013 11:25 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:05 PM
Points: 355, Visits: 870
I had seen this error when I was processing tons of records on a virtual machine. My solution was breaking the query down into batches. That is, using a loop to only process about 5,000 a time. Do you happen to know how long your query would take to execute without the out of memory hangup?
Post #1438930
Posted Tuesday, September 10, 2013 4:14 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Pls help me on this.

Pradeep
Post #1493082
Posted Tuesday, September 10, 2013 4:22 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 10:03 AM
Points: 1,106, Visits: 1,334
what your issue. symptoms?

Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Post #1493083
Posted Tuesday, September 10, 2013 5:18 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
When i am doing right click database >> Task >> restore >>database. I am getting below error

"Exception of type 'system.outofmemoryexception' was thrown"

Server configuration :

32 GB RAM
64 bit O/S
2 processors
Intel(R) Xeon(R) E5620 @2.40GHZ
service pack 2
SQL server 2008R2 (Standard Edition)

Note: In that server over all 850 databases which around 120 GB. And log shipping configured around 750 databases.

Error screenshot attached for ref.

thanks,


Pradeep

  Post Attachments 
Error.docx (5 views, 24.95 KB)
Post #1493109
Posted Tuesday, September 10, 2013 5:26 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:09 AM
Points: 883, Visits: 2,807
Are you running SSMS locally or on the server?





The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1493110
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse