FIX: 100% CPU usage when an in-memory OLTP database is in recovery state in SQL Server 2014

Symptoms

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.

Resolution

The issue was first fixed in the following cumulative updates of SQL Server:
Recommendation: Install the latest cumulative update for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

內容

文章識別碼:3099487 - 最後檢閱時間:2015年10月19日 - 修訂: 1

意見反應