Viewing 6 posts - 1 through 6 (of 6 total)
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,...
August 27, 2021 at 1:21 pm
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...
August 26, 2021 at 7:47 pm
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....
June 14, 2021 at 5:09 pm
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...
June 14, 2021 at 3:57 pm
I like the old floppies, and if you have some that you'd like to get rid of, send them to me.
February 8, 2021 at 6:19 pm
Very helpful, thanks Carolyn.
September 24, 2010 at 8:17 am
Viewing 6 posts - 1 through 6 (of 6 total)