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.

THEn
  • 137
  • 2
  • 8

1 Answers1

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

Sankar Reddy
  • 1,374
  • 8
  • 8
  • 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