asked
Unfamiliar messages in SQL server Error Log
In one of our production servers,we found below messages in sql server Errorlogs which is coming very frequently: [INFO] Database ID: [6]. Hardened root content for checkpoint timestamp 0x4e861963. [INFO] HkHostLogCheckpointRecord(): Database ID: [6]. Logged XTP checkpoint (v4) for timestamp 5612378467, serialize timestamp 5612378478: { Root ==> GUIDs = { Rowset {7898DB77-A098-4006-8EC5-E09389DBE2B6}, Column {42EBB4FB-845C-4722-A346-1605F2A76906} }, What does it mean? Note: on this server ,In_memory is enabled.
Are your in-memory objects (any of them) set to be DURABILITY of SCHEMA_AND_DATA?
This [article] (
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-xtp-checkpoint-stats-transact-sql) shares more information about checkpoints and how to query certain stats. It is very likely that this is just an informational message to let you know which quid was hardened as a result of the checkpoint and nothing concerning. Even though you say errorlog, lots of informational messages are written to the log, successful backups, successful checkdb scans, logins, etc. It's not just errors. :)
19 People are following this question.
