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.

When I run a simple query on server SSMS it takes 3 seconds. When I run the same query on my computer on SSMS it takes 35 seconds. What could be the reason? What should I check first? I tried disable the antivirus samething.

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

First thing to check is if the execution plans are same or NOT. And then next thing is to check the connection properties from both the machines. The below whitepaper might help you there.

http://www.sommarskog.se/query-plan-mysteries.html

share|improve this answer
    
Thanks, Execution plan is exactly the same. –  THEn Jun 17 '11 at 17:33
    
What happens if you run the same query for second time from your computer. Does it still take 35 seconds or runs quicker? –  Sankar Reddy Jun 17 '11 at 17:43
    
It takes same time always I don't think it is caching anything... –  THEn Jun 17 '11 at 17:47
    
Caching the data pages is a server concept and it is done automatically by SQL Server whether the request is coming from the server or from a different client. How simple is the query and can you share the execution plans from both? –  Sankar Reddy Jun 17 '11 at 17:58
    
Seems like index is messed up. What is the safest way to rebuild/reorgznize the indexes when many users are online? –  THEn Jun 17 '11 at 18:22
show 1 more comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.