Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1418
  • Last Modified:

time out occurred while waiting for memory resources

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
ShogunWade
Asked:
ShogunWade
  • 2
1 Solution
 
dfarthingCommented:
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
 
ShogunWadeAuthor Commented:
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
 
ShogunWadeAuthor Commented:
Its ok ive sussed it.

its the Query Wait option in sp_configure.

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now