SQL Server Performance

Timeout problem

Discussion in 'Performance Tuning for DBAs' started by the_vicar, May 16, 2005.

  1. the_vicar New Member

    Hi,
    I have SQL Server 2000 running on Win 2000 Server.
    I can view all the records in a table with "SELECT * FROM <tablename>"
    however when I try to be specific and specify a select criteria I get a timeout error as follows:
    "[Microsoft][ODBC SQL Server Driver] Timeout expired"

    I have checked and the timeout in the configuration options is set to 0 (unlimited).

    Any ideas what's the problem?

    I have one suspicion about the size of the table, however as I have no experience of SQL Server I'm unsure if this is a problem?

    The database consists of a single table, comprising of 37 columns and 54million rows.
    The server is twin 1.1GHZ with 1.8GB RAM.
    Is this a case of the table being to big? and would it generate a timeout error?

    Any ideas appreciated...

    Cheers.
  2. Madhivanan Moderator

    Did you use index for that table? Post your table structure


    Madhivanan

    Failing to plan is Planning to fail
  3. satya Moderator

  4. ghemant Moderator

    Please would you do more specific ? and could you describe your table structure ? and if you dont have index built on the field of criteria please try it, create a index and then execute the query i am sure it would be helpful.

    hsGoswami
    ghemant@gmail.com
  5. ranjitjain New Member

    Hi,
    Did u mean select * from table_name works well but
    select * from table_name where col1=1 gives you timeout error.

    From which application you are trying this. is it QA or some vb application.
    I hope you must have sp3 installed and mdac2.8 at client if its VB client.
    Try ITW and check the plan.

Share This Page