Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Query Time Out

Author  Topic 

indraneelkurane
Starting Member

1 Post

Posted - 2012-02-01 : 07:25:29
We have a table with 150000 records. It has a primary key on 3 columns and a index on 5 columns.

When a select query is executed on this table usully it takes 6 seconds to execute but some time it takes more than a 60 seconds and then 'Query Time out' message is reported.

This problem is seen intermittently.

What could be the solution for this? or What approach I should follow to derive proper solution?

Indraneel

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-01 : 08:25:06
Without seeing the query, it's hard to offer any really useful information.
Have you checked for blocking?

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -