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.
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.
|show 1 more comment|