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.
| 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 ShawSQL Server MVP |
 |
|
|
|
|
|
Query Time Out