Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

Your Answer


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.