Asynchronous AG Log Send Queue Growing then flushing quickly

Morning all,

Have a weird one. On one of our asynchronous servers the log send queue has just started growing and growing. Then the other day it was at 80gb then flushed everything to the log file in a couple of hours. It then had a day of being ok then it started doing it again, then it did the same thing and flushed everything at a random time. Then it started growing again.

SentryOne graph -

My Infrastructure team have had a look and can't see anything that would cause this. Network, CPU and disk all look fine. The only thing that shows up is that CPU and network resource goes really high when the queue finally flushes.

I've had a look at some XEvents and can't see any contention. All I see our some REDO_SIGNAL and REDO_THREAD_PENDING_WORK waits.

Running SQL Server 2012 S3 on both servers.

Anyone had anything like this?

avatar image By SystemsSQLAdmin 1 asked May 03, 2017 at 10:34 AM
more ▼
(comments are locked)
10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question



asked: May 03, 2017 at 10:34 AM

Seen: 178 times

Last Updated: May 03, 2017 at 10:34 AM