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 |
|
jonbryant
Starting Member
2 Posts |
 Posted - 2001-08-06 : 14:50:16
|
| I recently developed an application using ASP and SQL Server 7.0. As the size of the data in several of the tables grew, the response time a critical query began to increase beyond the client's tolerance level. I added two new indexes which seemed to fix the problem. The query went from running in about 10 seconds to about 2 seconds from within the Qeury Analyzer. I sent the client the SQL to update his server, but on his end the querystill ran in the 10 second range. SO I asked him to backup the database so I could restore it on my development box. I restored his backup and strangely, everything works fine on my end. What'seven stranger is that his server is a dual processer with something like 1/2 gigof ram, while my dev box is an average desktop pc. We eventually told the client that he needs to get a DBA to look at hisSQL Server Installation. I couldn't think of any reason why the querywould run fast on my machine and slow on his with identical data behind it.Does anyone have any ideas about what's going here, or what are some waysI could troubleshoot this problem?Thanks in advance,Jon |
|
|
|
|
|
Slow Query Response