Funnily enough I just came across an article which may be of some interest regarding this problem:
http://www.codeproject.com/Articles/24790/Faster-String-Building>I have four worker process answering the Web site. On one specific option a user did on the Web site, this has triggered a very long SQL command on SQL Server resulting in that process ID to take pretty much 100% of the memory available to it.
>
>Until we stopped that process, we ended up with several errors like this:
>
>"Exception of type 'System.OutOfMemoryException' was thrown."
>
>When looking at the trace, it was normal to see that the trace was pretty much different for each of them as, when there is no more memory available to process a transaction, an error can happen everywhere.
>
>However, what I do not understand, is one of them has this scenario. The Stack Trace ends up with at System.Text.StringBuilder.ToString() as the last item in it. This is from this method:
>
>
> ' Equivalent of VFP StrTran()
> ' expC1 String
> ' expC2 Search for specific character
> ' expC3 Replace
> Public Function StrTran(ByVal tcSearchIn As String, ByVal tcSearchFor As String, _
> ByVal tcReplace As String) As String
> Dim loStringBuilder As StringBuilder = New StringBuilder(tcSearchIn)
> Return loStringBuilder.Replace(tcSearchFor, tcReplace).ToString()
> End Function
>
>
>So, basically, because of a memory issue, the StringBuilder was not able to execute. However, as surprisingly as it gets, the insert into SQL Server to log this error worked.
>
>So, can anyone explain me why a simple command like that could trigger a 'System.OutOfMemoryException' when, at the same time, after it failed at that location, I was able to execute an insert into SQL Server?