I am Running SQL Server 2019 on my Instance, and my Databases are running with the old target recovery time (which is 0, We were on SQL Server 2014 Before).
After reading the documentation:
https://learn.microsoft.com/nl-nl/sql/relational-databases/logs/change-the-target-recovery-time-of-a-database-sql-server?view=sql-server-ver16
I saw that The default setting changed to 60 starting SQL Server 2016.
but also I saw that There can me some drawback with switching to indirect checkpoints (extra I/O activity on certain systems),
my question is did anyone try to change the old default and had any problems with the change?
and what should I consider before implementing the change?
At the moment only research before implementing