Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

time out occurred while waiting for memory resources

Posted on 2004-09-07
4
Medium Priority
?
1,413 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

885 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