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 ««12

An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown. Expand / Collapse
Author
Message
Posted Friday, October 11, 2013 12:20 PM This worked for the OP Answer marked as solution
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 14, 2013 11:24 AM
Points: 1, Visits: 3
My best guess is that the garbage cleanup in SSMS is flawed.
I get this error repeatedly, usually under the following circumstances:
1. SSMS has been open for a long time (days...I don't usually shut down my PC at work)
2. Have at least 4-5 minimum query windows open
3. SSMS is using around 700MB of ram on my PC

At some point, even a request for just a table with a few rows of data will show this error.

Even if I close all query windows and open a new fresh window, the error still persists.

We're using SQL Server 2012 on the server, and SSMS for SQL Server 12 on local client machines.
All developers in our group have experienced this error at one time or another.

Advice to Microsoft: Once a query window is closed, clean-up memory to allow for new work to commence.



Post #1504118
Posted Thursday, January 23, 2014 3:48 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 4:07 AM
Points: 365, Visits: 966
Ditto. I do leave SSMS running for a few days, and I get it moaning at me. I've got 11GB of RAM free on my workstation and still it complains.

"An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown."

The GUI is also slower than 2008R2 when doing restores - yes I can code but sometimes its just nice to be lazy and use the GUI.

Two steps forward one step back...

Post #1533981
Posted Friday, April 4, 2014 9:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 24, 2014 3:18 PM
Points: 3, Visits: 9
The same is for SSMS 2012..it loses the plot also. Simply save your work and restart it and the problem is solved.
Post #1558693
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse