Generating "System.OutOfMemoryException errors" (186061)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

Generating "System.OutOfMemoryException errors"
Description

When dealing with a huge amount of data when running queries, frequently returns Out of Memory errors.
The following error is displayed :"System.OutOfMemoryException errors"
Cause

It happens sometimes when the cache is exceeded by the size of the data to retrieve.
Resolution

WORKAROUND:

1. Go to Tools | Options | Database | Cache
2. Clear cache and increase memory, (by default is 10 Mb)
3. Click on Apply | OK
4. Restart Toad for SQL Server
5. Return to Options | Database | Cache | >> Verify the new value was saved.

Feedback submitted.

Was this article helpful?

[Select Rating]

Title