I'm getting this error in one of my prod SQL Server 2005 64bit servers with 32GB RAM out of which I have allocated 27GB to SQL Server.
Error: 8645, Severity: 17, State: 1
A time out occurred while waiting for memory resources to execute the query. Rerun the query.
Also seeing atleast 2 SQLDump000.mdmp files
I know that when we have more .mdmp files its a sign of memory crunch on the server and the server needs a restart.
I would appreciate if anyone could share few more thoughts on this?