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.
Each new cumulative update for SQL Server contains all the hotfixes and security fixes that were included in the previous cumulative update. Check out the latest cumulative updates for SQL Server 2014.
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.
