March 17, 2009 at 2:20 pm
We have a client who is complaining about really slow response time during a process. There is a table that is updated during the process that takes 45 seconds to update. I'm not sure if it is the culprit but this is what I know.
1) When I go in to Query Analyzer and perform a select count(*) on that table, it takes 29 seconds to return.
2) If I run the query again immediately after, it is faster and gets faster every time.
3) There are about 70,000 rows in that table.
4) I ran this on the table yesterday which didn't help:
update statistics my_table with fullscan
exec sp_recompile my_table
5) The table has about 140 columns.
6) There are 5 columns that are not null.
7) There is an index using these 5 columns and these values are checked: clustered index, unique values, filegroup - primary, fill factor -90.
If I perform some re-index, how can I test it to see if it worked? Like I mentioned, Sometimes the query takes a long time and sometimes it doesn't - maybe the server has the query plan in memory. How can I remove it?
What can I do?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply