SSMS – “An error occurred while executing batch. Error message is: Exception of type ‘System.OutOfMemoryException’ was thrown”

Background

Eventful day this morning, had to take a walk around the office block.

You know it is a good day when you wake @ 4: 30 AM, pulled in the smartphone and heard what smart bloggers have to say, make the 5:30 AM Bus, made the train and walked the lake just to feel good about work.

Error

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

Remediation

It is not the Server, but your client, Sql Server Management Studio ( SSMS), in this case.

No need to reboot, but closed the Chrome Tabs, and when that did not help, exited SSMS.

 

Culprit

May be too much “Query Execution Plan” digest.

Looking for a lot of things through the Graphics pane; graphics is always more taxing on system.

Heart

Heart and I spoke about the next few days and how everything is sane and good.

 

Listening

Have a nice bit of work in, and it is only 2 PM.

Daryl Worley
Second Wind
Link

Don’t need a second wind, but can relate….

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s