I ran into this issue recently (Feb 2023) and spent some time trying to figure out what's going on. I knew this must have been something simple in the configuration...

We had users who were reading from the secondary. Before, we were just trying to kill the blocking sessions but that wasn't always successful in reducing the queue size. However,...

Ronald,

One thing I found out through painstaking trial and error is that I can control the flow if I turn off the secondary read from the primary replica. When I...

Right on and hence lies the problem, some process that's preventing quick processing of redo logs. TempDB is setup very generously and nicely divided into multiple files on the server....

Hi Jeff,

Thanks for the reply. It's almost always behind. Except async auto updates, I don't do any other index maintenance. I see a constantly multiple hundreds of GB of redo...

I like the old floppies, and if you have some that you'd like to get rid of, send them to me.

Very helpful, thanks Carolyn.