Close this search box.

Fixing Parallel REDO Thread in Always On

Parallel REDO ThreadMost of the time I find some or other topic to write on my blog sphere during my weekend on-call, last week was no exception. A client has a monthly reboot schedule for few servers spanning over two days – Saturday and Sunday. All these servers are configured with Always On, a Primary, a Secondary and a DR node. While working on this activity, a couple of servers did not catch up on synchronization, few databases were having an issue and they stuck at some point. This issue is known to the client, it is called – Parallel Redo Thread.

What it means is, there are main and slave threads for REDO queue and what engine does is, it performs queuing, analyzing or dequeuing streams of data so that it can be sent to slave threads. And, when it find another thread that sends data streams to Secondary/DR threads i.e. Index Rebuild operation it makes the operation little slower for this REDO thread.

Fixing Parallel REDO Thread in Always On

Fixing this issue needs recycle SQL Server service by adding trace flag 3459 as the startup parameter. What this trace flag will do is, it will disable Parallel REDO Thread and thus help to fix the issue.

Reading on Parallel REDO Thread

Parallel REDO Thread can cause you high memory usage as well according to Microsoft, I haven’t found much more details on this yet but here are couple of links that you can read

I assume that this detail will prove helpful to you to some extent. Do let me know in case you have much more and detailed information regarding this issue of Parallel REDO Thread as I am interested in reading more on this and if we have a permanent fix available. In the meantime, you may want to browse through HADR and Troubleshooting section of my blog space for more troubleshooting tips like troubleshooting Always on Synchronization issue.

You may also want to download my script to monitor AlwaysOn Health.

photo credit: Marcus Rahm tooltime via photopin (license)

Leave a Reply

Your email address will not be published. Required fields are marked *

Picture of Hemantgiri Goswami

Hemantgiri Goswami

Throughout my extensive 24-year tenure in the IT industry, I have honed my expertise in SQL Server and cloud technologies. My qualifications include certifications in ITIL, Azure, and Google Cloud, and my professional journey boasts a consistent record of delivering top-notch, dependable, and efficient solutions across diverse clients and domains. In recognition of my dedication and impact, I am honored to have received the Microsoft MVP award for SQL Server on six occasions. Additionally, I actively contribute to various online forums and blogs, acting as a moderator and facilitator of meaningful discussions. My ultimate mission revolves around empowering organizations to enhance the reliability and efficiency of their SQL Server implementations while fostering a culture of continuous learning and growth within the SQL Server community.