03 July,2012 by Jack Vamvas
Question: We had a hardware failure which caused the server supporting the ESX host to crash. The administrator issued a VMotion onto another server in the Cluster. Upon restart the SQL server is recovering very slowly. What can be causing this delay?
Answer: A variety of reasons cans cause a slow recovery on a SQL Server restart after a hardware failure or power outage , possibilities include
a) CHECKPOINT hadn’t run after a large amount of transactions. This leaves SQL dirty pages
b) SQL Server had a large amount of active transactions when the server crashed
c) SQL Server shutdown was not clean. Hardware failure\ power outage are typical reasons.
d) The sp_confgure option “recovery interval” is not at the default setting (default = 0) . Basically , recovery_interval manages the checkpoint frequency.
Follow these steps - Server sudden shutdown unavailable