Home / server / Questions / 920146
In Process
Gavin Coates
Asked: 2018-07-10 08:54:16 +0800 CST

Parallel Redo Is Shutdown

  • 772

When looking in Windows event logs, i'm seeing the following messages on an almost continuous basis -

Starting up database 'Database'. Parallel redo is started for database 'Database' with worker pool size [1]. Parallel redo is shutdown for database 'Database' with worker pool size [1].

These messages happen at the same time, and repeat continuously every second.

Can someone explain what Parallel Redo is, and why it's continually starting and stopping, and causing the database to have to restart?

The database is being used by an ASP.NET web application using Entity Framework, running on IIS. Windows Server 2016 Standard and SQL Server 14.0.100 (Sql Server 2017 Express Edition).

sql-server

1 Answers

  1. Try setting auto close to false, this can be done in the option section of the DB properties.

    Here's a link to explain this. Someone commented something similar on the thread below. https://dba.stackexchange.com/questions/239181/messages-about-parallel-redo

    • -1