Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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)

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.