Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Network issue? Expand / Collapse
Posted Tuesday, February 12, 2013 8:41 AM


Group: General Forum Members
Last Login: 2 days ago @ 7:17 AM
Points: 412, Visits: 767
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?
Post #1419010
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse