Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 7:50 AM
Points: 327, Visits: 586
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