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.

more ▼

asked May 11, 2017 at 08:33 AM in Default

avatar image

21 1

Are your in-memory objects (any of them) set to be DURABILITY of SCHEMA_AND_DATA?

May 11, 2017 at 12:14 PM ThomasRushton ♦♦

No ,it is set to schema only for in_memory tables.

May 17, 2017 at 10:12 AM chandu17
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

This article 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. :)

more ▼

answered May 11, 2017 at 01:41 PM

avatar image

40.9k 39 95 168

but i just want to know ,what kind of information it is giving and from which process it is related.

May 17, 2017 at 02:23 PM chandu17

Did you query the DMV mentioned in the article I provided?

May 17, 2017 at 03:42 PM Tim
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 11, 2017 at 08:33 AM

Seen: 103 times

Last Updated: May 17, 2017 at 03:42 PM

Copyright 2018 Redgate Software. Privacy Policy