| title | SQL Server XTP Transaction Log object | |||
|---|---|---|---|---|
| description | Learn about the SQL Server XTP Transaction Log performance object, which contains counters related to In-Memory OLTP transaction log activity in SQL Server. | |||
| author | MikeRayMSFT | |||
| ms.author | mikeray | |||
| ms.date | 12/04/2023 | |||
| ms.service | sql | |||
| ms.subservice | performance | |||
| ms.topic | reference | |||
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
The SQL Server XTP Transaction Log performance object contains counters related to In-Memory OLTP transaction log activity in [!INCLUDE ssNoVersion].
This table describes the SQL Server XTP Transaction Log counters.
| Counter | Description |
|---|---|
| Log bytes written/sec | The number of bytes written to the [!INCLUDE ssNoVersion] transaction log by the In-Memory OLTP engine (on average), per second. |
| Log records written/sec | The number of records written to the [!INCLUDE ssNoVersion] transaction log by the In-Memory OLTP engine (on average), per second. |
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%';