In the Large Checkpoint mode, an automatic checkpoint is taken when the transaction log file is larger than 12 gigabytes (GB), which is eight times larger than the normal mode. However, database recovery may be very slow in this mode because of the large log (may be as large as 12 GB).
The issue was first fixed in the following cumulative update of SQL Server:
ID articol: 3171001 - Ultima examinare: 26 iul. 2016 - Revizie: 1