| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Server XTP Transaction Log object |
Learn about the SQL Server XTP Transaction Log performance object, which contains counters related to In-Memory OLTP transaction log activity in SQL Server. |
MikeRayMSFT |
mikeray |
12/04/2023 |
sql |
performance |
reference |
|
[!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%';