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
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 25, 2012 9:31 AM
Points: 6, Visits: 70
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 04, 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: Tuesday, April 01, 2014 3:44 PM
Points: 1,266, Visits: 2,912
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 04, 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 03, 2013 3:20 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 AM
Points: 90, Visits: 311
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 04, 2013 11:25 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:20 PM
Points: 220, Visits: 695
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, April 14, 2014 4:18 AM
Points: 90, Visits: 311
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 04, 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, April 14, 2014 4:18 AM
Points: 90, Visits: 311
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


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, April 14, 2014 11:49 AM
Points: 739, Visits: 2,470
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