November 24, 2014 at 1:57 pm
hello,
someone can tell me what this message mean
An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown.
i got it when i try to execute a select on a table of my database.
thank you.
November 24, 2014 at 2:02 pm
This has happened to me when the result set is too large to be displayed. Try returning less rows or use a different client application.
November 25, 2014 at 6:00 am
In addition to just too much data, you can see this if you have extremely complex queries such as views that call views that join to views, etc.
Short answer, whatever you're trying to do, you don't have enough memory to do it. You either need to modify your query or you need to buy more hardware.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 25, 2014 at 6:10 am
To be clear, this is a client-side error. It's Management Studio that's running out of memory, not SQL Server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2014 at 7:29 am
I've also received the error when I try to copy very large query results. The query runs, but about 1 second after I hit Ctrl-C, SSMS throws the error. Like Gail said, it's definitely in SSMS on my workstation; the server is fine.
November 25, 2014 at 10:52 am
Stop trying to copy and paste millions of rows out of management studio.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply