Re: SQL Server 2000 query time out option, what does it do?

We had a situation where a user in Access left a drop down menu open all
night. The drop down menu ran a select query for 13 hours. The query only
completed when the user ended the session the next day. The focal for the
application would like SQL Server to terminate the query if it takes over 5
or 10 minutes to complete. The select statement left a lock on the table
and updates and index reorgs were held up. I think SQL sees the query as a
valid running query and the timeout is ignored.


"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns9759B9DDB75C0Yazorman@xxxxxxxxxxxx
> Robert (robert.j.sipe@xxxxxxxxxx) writes:
>> Can anyone tell me what the query time out is for? It is not acting as
>> I would exepct
>
> The query timeout is for queries to remote servers. I will have to
> admit that I have not investigated the option in depth, although we
> have had cases at work where we have run into such timeouts.
>
> What are your expectations?
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


.

Relevant Pages

  • Re: Problem using Access or Query Designer to run queries in SQL S
    ... The need for the group of financial analysts I support, is some ad-hoc query ... Therefore stored procedures called via pass-thru queries ... for their Access/Excel queries to fetch data from SQL server is still a huge ... I can instruct them to set the ODBC timeout ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQL Server 2000 query time out option, what does it do?
    ... The drop down menu ran a select query for 13 hours. ... > SQL sees the query as a valid running query and the timeout is ignored. ... When a client runs a query on SQL Server, and gets back a result set, to ...
    (comp.databases.ms-sqlserver)
  • Re: CONTAINS performance
    ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL Timeout Errors - Can Anyone Help?
    ... The timeout period elapsed prior to completion of the ... SQL Server does not time out. ... and you get further blocking and timeout. ... There are two possible reasons why a query takes more than 30 seconds ...
    (comp.databases.ms-sqlserver)
  • Re: Very slow query
    ... with lots if information in Books Online, Books, Courses, the Net etc. ... While testing the query in QA, use the "Show Estimated Query Plan" feature. ... This is what I suggest you also pick up using Profiler. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)