0

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.

1

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

5
  • 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
  • If you have enterprise edition then you can use ONLINE flag to build the index online otherwise try reorganizing the index (which is slow, and NOT as effective as REBUILD). – Sankar Reddy Jun 17 '11 at 18:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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