SQL Server XTP Transaction Log object

Applies to: SQL Server

The SQL Server XTP Transaction Log performance object contains counters related to In-Memory OLTP transaction log activity in SQL Server.

This table describes the SQL Server XTP Transaction Log counters.

Counter	Description
Log bytes written/sec	The number of bytes written to the SQL Server transaction log by the In-Memory OLTP engine (on average), per second.
Log records written/sec	The number of records written to the SQL Server transaction log by the In-Memory OLTP engine (on average), per second.

Examples

You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:

SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%XTP Transaction Log%';

Related content

• In-Memory OLTP overview and usage scenarios
• SQL Server XTP (In-memory OLTP) Performance Counters