I had an issue that loading data for fine-tune the restore point took felt forever (ok, it took about 10 minutes). For me that is too long therefore I filed a case. In the end we found out that the log backups didn't contain enough transactions and therefore all log backup were loaded regardless of selected point in time. Loading data for fine tune a restore point for a heavy utilized database is much faster because only one log backup is loaded to display fine tune data. Here my wish to R&D:
- Add a hint to documentation, that loading data (respectively loading transactionlogs) may take long time because more transaction logs are loaded due to too few number of transaction within one log backup file.
- Only load a small number of log backups regardless of the number of transactions in log backup for display fine tune data.
- A registry key to control log backup loading behavior for fine tune.
Could anyone please take this request into account?