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 |
|
Rangi
Starting Member
18 Posts |
 Posted - 2003-05-09 : 09:58:06
|
| Hi,I have a strange problem regarding query speeds when executing the queries in Query Analyzer. Sometimes I execute a simple query and it takes less than a second. It might work several times like that. Then, I might repeat the query and it could take several _minutes_!I didn't used to have this problem but we had hardware trouble and had to reinstall the OS and SQL Server, and now this is happening. It's been happening for months now.When I execute queries from a web application, it's much faster, and I don't think a query ever takes several minutes.Any help would be very much appreciated,Rangi |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-09 : 11:49:36
|
| What does that mean?How many rows of data? Are the predicates Indexed? Were the previous results in buffer? Are there updates going on when you're selecting? Do you use (NOLOCK) for dirty reads?Post the DDL of the "simple" query.Brett8-) |
 |
|
|
|
|
|
Dramatically different query speeds