January 22, 2014 at 11:07 pm
Hi,
While executing an stored procedure in SQL Server 2008, which retrieves data in xml format is throwing the error - System.OutOfMemory. What would be the possible reasons for this error been thrown?
Regards,
Sai Viswanath
January 23, 2014 at 2:48 am
You're running the client application out of memory. That's not a SQL Server error message.
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
January 23, 2014 at 3:00 am
Hi Gila,
Am executing the SP from SQL Server Query window. A little background of the sp is - it calls other sp's internally to retrieve the data, and this error is getting posted when working on the production server. The same sp works fine when the output is small. Hope this explanation is clear, if not any further information required do get back.
Regards,
Sai Viswanath
January 23, 2014 at 3:24 am
Again, your client application is running out of memory, probably due to the large result set. This is not a SQL Server error message, it's coming from whatever .net client application you have displaying the data.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply