Solved

time out occurred while waiting for memory resources

Posted on 2004-09-07
4
1,402 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

615 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