14

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).

3
  • On a recent instance (SQL Server 2017 CU8 Standard Edition) restart, I had one of these messages for each of my user databases in the log. I've never seen it before. I'm curious to see what responses you get. Jul 17, 2018 at 21:32
  • Surely someone knows what Parallel redo is?? Jul 24, 2018 at 12:51
  • 2
    Same thing here running mssql-server-Linux:latest in a docker container. Did you ever find any clues as to what causes this?
    – Gavin
    Sep 11, 2018 at 9:41

1 Answer 1

-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
  • 5
    To achive ... what?
    – bjoster
    Jun 4, 2019 at 13:02

Not the answer you're looking for? Browse other questions tagged or ask your own question.