Solved

time out occurred while waiting for memory resources

Posted on 2004-09-07
4
1,377 Views
Last Modified: 2012-08-13
Hi all,  another chanlanging one.

Ive got so much stuff running that I got this error.    Its the first time ive ever seen this,  whilst I totally understand what it is and why it has occured, the question is..... Does anyone know of a way that I can increase this particular timeout interval, or is this hard coded in the bowels of SQL Sever?


Server: Msg 8645, Level 17, State 1, Line 1
A time out occurred while waiting for memory resources to execute the query. Rerun the query.


Cheers
0
Comment
Question by:ShogunWade
  • 2
4 Comments
 
LVL 3

Expert Comment

by:dfarthing
ID: 11995442
Hi,

Load up enterprise manager, right click your server and select properties. now select the connections tab and you will see a query time out setting in seconds. if you set it to zero it make the query time unlimited.

Hope it helps

Duncan
0
 
LVL 18

Author Comment

by:ShogunWade
ID: 11995453
No, that is connection timeout and command timeout settings.  both of them are set as unlimited.    This is a different issue at a much lower level.  Its a memory Allocation timeout.
0
 
LVL 18

Accepted Solution

by:
ShogunWade earned 0 total points
ID: 11995541
Its ok ive sussed it.

its the Query Wait option in sp_configure.

0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question