yesterday i had several Problems in a Windows Service with a Function that already works and runs several Months without a Problem.
But yesterday i got alot of Errors in my Service. The Errormessages were a Combination of mostly these Twos.
The connection does not support MultipleActiveResultSets. Connection Timeout Expired. The timeout period elapsed during the post-login phase.
I did not have changed anything in the past 2 Months and had never Problems with this Service.
While searching the Problem i stumbled over these SQL-Server Log Messages
Parallel redo is shutdown for database '' with worker pool size . Parallel redo is started for database '' with worker pool size . Starting up database ''
Theses Messages appeared also in the Past, periodically they occured.
But yesterday they happened in a extremly high Frequency. They have started around 5 Hours after the Backup Process and lasts for about 7 Hours.
I'll had nearly 300'000 Events. These 3 Messages together occured around 3-4 Times per Second and suddenly they stopped.
Im not sure anymore if they stopped after i ended the Service, but as this Message have stopped to occur in this High Frequency, my Service also had no Problems anymore. Im not sure if these 2 Instances (Sql-Server and Windows Service) were rocking each other up.
I'll kinda understand what leads to this Messages, but not what why it were spammed like this.
Any Ideas on how to prevent this and / or ways of investigating this further?
All the Best Daniel