We are doing Volume Snapshot restoration from Production to Warm Stand-By Server on daily basis. Daily it takes around 10 mins for DB to recover. But yesterday it took 44 mins to recover.
I am confused on where exactly the time was spent (analysis only took ~12.5 minutes) and once I identify that I want to know why it happened and how can we fix it.
Recovery completed for database XXXXXXX (database ID 7) in 2612 second(s) (analysis 748452 ms, redo 0 ms, undo 814 ms.) This is an informational message only. No user action is required.
Note: There are only 53 VLFs in the log file, ranging in size from 6 MB to 244 MB (auto growth setting for the log file is 10%).
Total DB Size: 4598 MB Log File Size: 2698 MB
Microsoft SQL Server 2016 (SP2-CU8) (KB4505830) - 13.0.5426.0 (X64) Jul 21 2019 21:16:47 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Standard 6.3 (Build 9600: ) (Hypervisor)