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

Mirror job taking longer than an expected Expand / Collapse
Author
Message
Posted Thursday, October 10, 2013 3:47 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:13 AM
Points: 200, Visits: 702
I use redgate's SQL monitor to monitor my servers and lately my mirror job is taking longer then usual. It normally completes under a second running every minuted but i get spikes which are happening more frequently and can take up to 20 secs to mirror the data. The servers are literally next to each other so its not a network issue.

I get alerts in this order normally

Job name:	Database Mirroring Monitor Job
Job started at: 10 Oct 2013 10:23 AM
Job ended at: 10 Oct 2013 10:23 AM
Job outcome: Succeeded
Duration: 00:00:08
Baseline duration (median of last 10 runs): 00:00:00
Deviation from baseline: --
Job next scheduled to run at: 10 Oct 2013 10:43 AM

Followed by

Job name:	Distribution clean up: distribution
Job started at: 10 Oct 2013 10:25 AM
Job ended at: 10 Oct 2013 10:25 AM
Job outcome: Succeeded
Duration: 00:00:12
Baseline duration (median of last 10 runs): 00:00:00
Deviation from baseline: --
Job next scheduled to run at: 10 Oct 2013 10:45 AM

Do you guys/gals know any counters or tests i can use to try find out why this latency is occurring?

Thanks
Post #1503437
Posted Saturday, October 12, 2013 10:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 6,752, Visits: 14,400
bugg (10/10/2013)
The servers are literally next to each other so its not a network issue.

Although they are next to each other, they presumbaly plug into a network switch, is this the same switch or different switches?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1504214
Posted Saturday, October 12, 2013 10:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:13 AM
Points: 200, Visits: 702
Perry Whittle (10/12/2013)
bugg (10/10/2013)
The servers are literally next to each other so its not a network issue.

Although they are next to each other, they presumbaly plug into a network switch, is this the same switch or different switches?


Hmm good point Ill check this out
Post #1504216
Posted Monday, October 14, 2013 3:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:13 AM
Points: 200, Visits: 702
bugg (10/12/2013)
Perry Whittle (10/12/2013)
bugg (10/10/2013)
The servers are literally next to each other so its not a network issue.

Although they are next to each other, they presumbaly plug into a network switch, is this the same switch or different switches?


Hmm good point Ill check this out


They are both connected to 2 different switches in case one of the switches fails. Both are connected to switch A and both are connected to Switch B.
Post #1504371
Posted Monday, October 14, 2013 5:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 6,752, Visits: 14,400
are the NICs teamed then?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1504408
Posted Monday, October 14, 2013 6:53 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:13 AM
Points: 200, Visits: 702
Perry Whittle (10/14/2013)
are the NICs teamed then?


Yes they are teamed, one can transfer only and the other can transfer and receive. Both seem to be running fine with no faults.
Post #1504428
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse