November 3, 2015 at 1:08 pm
I ran into interesting issue that i see no mentioning of in documentation or anywhere online. Perhaps smart people can point me in the right direction.
I have a fairly heavily used SQL2008R2 cluster based on Symantec Storage Foundation HA. Many databases are mirrored to another datacenter across continent. Mirroring is set to 'asynchronous, high-performance'. Under normal conditions everything runs OK, no big latency. WAN acceleration helps a lot.
During peak load hours of the day, for about 2-3 hrs, SQL server automatically suspends mirroring and resumes it after peak load subsided. mirroring than catches up ok on all databases and life is grand again. the problem is that during these 2 hours, i do not have proper DR.
I attached snippet of graph that represents network traffic during the period. Dark green is incoming traffic.
Does anyone know of any settings in SQL server that control mirroring bandwidth or anything else that can contribute to this behaviour?
November 4, 2015 at 2:52 am
Hi Sam,
Not sure if this will be much help - had a similar issue before the following post help diagnose the issue
November 9, 2015 at 1:23 pm
Mirroring has a timeout value increase it, so it does not become disconnected due to connectivity issues.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply