Assume that you have an in-memory online transaction processing (OLTP) database in Microsoft SQL Server 2014, and the database contains a memory optimized table with a nonclustered index. In this situation, database recovery may take longer than expected, and the CPU usage may approach 100 percent during the recovery process. Note
- Memory optimized tables with only hash indexes are not affected by this issue.
- Recovery can occur when you start an instance of SQL Server, restore a backup or set a database online.