up vote 0 down vote favorite
share [g+] share [fb]

I have note, that responding time for query is act like sinusoid. Once this time is very short, another time my app must wait abount 10 min for query result. Problem start when I install update my server from SQL 2005 SP2 to SQL 2005 SP3 (including all other fixes and patches)

link|improve this question
Without more information there's really nothing we can tell you other than to check the usual things like other processes that are running, state of your indexes, etc. – squillman Jul 22 '10 at 14:08
Processes looks fine but how to check indexes I do not know. Looking for any solution, I have read some article about problem with indexes when installing SP3 to SQL 2005 with SP2. How can i check is my indexes are good? – hubertus Jul 22 '10 at 14:49
1  
could you specify your query? – igor Jul 23 '10 at 8:55
SELECT * FROM USERTB WHERE Value_5 = 'something'; I recently notice that rebuild indexes help momehow. Slow down i shorter and much more rare. But slow query response happens. – hubertus Jul 27 '10 at 8:41
I notice very important thing. If my query has 'ORDER BY' clause response time is dramaticly long. Simple 'SELCT' like above is 1 sec long. what can be wrong? – hubertus Jul 28 '10 at 7:21
show 1 more comment
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.