Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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"
원인
It happens sometimes when the cache is exceeded by the size of the data to retrieve.
해결 방안
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.