FIX: Many HkHostLogCheckpointRecord() messages in SQL Server error log

Applies to: SQL Server 2014 Enterprise

Symptoms


Assume that you use SQL Server 2014, and you have Memory Optimized tables that were created in the SQL Server Database. When highly frequent checkpoints occur in the database, many messages that resemble the following are logged in the SQL Server error log. This makes it difficult to check for important messages in the error log.

date time spid503s    [INFO] Database ID: [90]. Hardened root content for checkpoint timestamp 0x0008d1e3.
date time spid214s    [INFO] HkHostLogCheckpointRecord(): Database ID: [90]. Logged XTP checkpoint (v4) for timestamp, serialize timestamp:  { Root ==> GUIDs = {Rowset {}, Column {}}, RecoveryLSN, PreviousCompleteCheckpoint LSN, Close LSN, Complete LSN, Root LSN , MRT LSN, DeltaWatermark LSN, BackupFileCollection LSN}

Resolution


This issue is fixed in Cumulative Update 5 for SQL Server 2014 Service Pack 2.

Status


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

References


Learn about the terminology Microsoft uses to describe software updates.