I have a job that kicks off on (lets say) server A, and it runs two SQL statements with the FROM being a different server... lets say server B. Now the trace logs for both servers do not show any memory pressure, the only I/O wait is 4, and the CPU's never reach 60%.
The job kicks off and shows up in the trace log on server A, but it is 5 min later before the SQL shows up on server B's trace log. Then it quickly runs all the sql statements, and then server A shows the completion of the job.
I can not .. figure out why this nights job went from running in about 40 sec, to almost 6 min. Other than some strange network issue, can anyone give me any idea's why server B took so long to have the first query show up in it's trace?