| title | SQL Server XTP Transactions | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 03/14/2017 |
| ms.prod | sql |
| ms.prod_service | database-engine |
| ms.reviewer | |
| ms.technology | performance |
| ms.topic | conceptual |
| ms.assetid | 443d67e4-1c7f-41d7-b18d-2d657f58c22a |
| author | julieMSFT |
| ms.author | jrasnick |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
The SQL Server XTP Transactions performance object contains counters related to transactions involving In-Memory OLTP in [!INCLUDEssNoVersion].
This table describes the SQL Server XTP Transactions counters.
| Counter | Description |
|---|---|
| Cascading aborts/sec | The number of transactions that rolled back to due a commit dependency rollback (on average), per second. |
| Commit dependencies taken/sec | The number of commit dependencies taken by transactions (on average), per second. |
| Read-only transactions prepared/sec | The number of read-only transactions that were prepared for commit processing, per second. |
| Save point refreshes/sec | The number of times a savepoint was "refreshed", (on average), per second. A savepoint refresh is when an existing savepoint is reset to the current point in the transaction's lifetime. |
| Save point rollbacks/sec | The number of times a transaction rolled back to a save point (on average), per second. |
| Save points created /sec | The number of save points created (on average), per second. |
| Transaction validation failure/sec | The number of transactions that failed validation processing (on average), per second. |
| Transactions aborted by user/sec | The number of transactions that were aborted by the user (on average), per second. |
| Transactions aborted/sec | The number of transactions that aborted (both by the user and the system, on average), per second. |
| Transactions created/sec | The number of transactions created in the system (on average), per second. XTP transactions are counted differently than disk-based transactions (as reflected in Databases:Transactions/sec). For example, Transactions created/sec counts read/only transactions, while Databases:Transactions/sec does not. |