April 13, 2005 at 12:20 pm
Just today, across multiple users, we are receiving the SQL error:
A time out occurred while waiting for memory resources to execute the query. Rerun the query.
We have a CRM system that controls how the queries run. We do not generally run custom queries.
Server is:
Win2K SP4.
SQL 7.0 SP2
4 Procs
3GB Memory
Thanks! It's getting worse!
April 13, 2005 at 2:02 pm
Take a look at this article. It gives you some options to try and figure out what queries are causing the issue as well as some mediation possibilities, especially for SQL Server 7.0
How to troubleshoot SQL Server Error 8645 (309256)
K. Brian Kelley
@kbriankelley
April 14, 2005 at 8:08 am
Also look in the SQLServer log to see if there are any memory error messages. It can be caused by one query that needs a lot of contiguous memory.
The general rule is: find out whats changed. I bet one of the developers has made one of the queries 'a little more complicated' so that it now need a lot of contiguous memory.
Peter
April 14, 2005 at 12:53 pm
Thank you for the responses, I will do some follow-up. We ended up rebooting the server which solved it this time. It was odd since it was a record breaker for the number of users logged in.
Thanks again!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply