Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here




Hello. I was lead here with a hint that it is a site that could help me with my problem.
So to cut a long story short, i would appreciate if you could have a look at the problem i am facing.
Al the info is here:

RE: http://www.vbforums.com/showthread.php?778981-Very-strange-time-difference-in-2-sprocs-run-through-a

Would appreciate if relevant info is posted here - no point in jumping on and off 2 sites to see what is going on.

Thinks to look at.
linked servers configuration - is it all the same?
local and remote server - is packet size configured same way on all servers?
network connections - are all switches/routers between local server and the different remote servers all configured the same way and have all the same capabilities (e.g. 10Gbit vs 1Gbit network?)
servers memory, HD configuration and speed, number of cpus, maxdop, size and configuration of tempdb, etc - all equal in all servers?

you are executing a query on remote server and inserting into a local server - what happens when you execute and insert the results into a table on the remote server instead of the local one?

you mention same execution plan - this is the less important aspect of it - run the proc in each server (localy on each server itself) and look at statistics IO - see what is the difference in terms of physical and specially logical reads


Frederico Fonseca
SysSoft Integrated Ltd

FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close