SQL Server XTP 트랜잭션SQL Server XTP Transactions

이 항목은 다음에 적용됩니다. 예SQL Server(2016부터 시작)아니요Azure SQL 데이터베이스아니요Azure SQL 데이터 웨어하우스아니요병렬 데이터 웨어하우스THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server XTP 트랜잭션 성능 개체에는 SQL ServerSQL Server의 메모리 내 OLTP 트랜잭션과 관련된 카운터가 포함됩니다.The SQL Server XTP Transactions performance object contains counters related to transactions involving In-Memory OLTP in SQL ServerSQL Server.

이 표에서는 SQL Server XTP 트랜잭션 카운터에 대해 설명합니다.This table describes the SQL Server XTP Transactions counters.

카운터Counter 설명Description
Cascading aborts/secCascading aborts/sec 커밋 종속성 롤백으로 인해 롤백되는 초당 트랜잭션 수입니다(평균).The number of transactions that rolled back to due a commit dependency rollback (on average), per second.
Commit dependencies taken/secCommit dependencies taken/sec 트랜잭션에 의해 사용되는 초당 커밋 종속성 수입니다(평균).The number of commit dependencies taken by transactions (on average), per second.
Read-only transactions prepared/secRead-only transactions prepared/sec 커밋 처리를 위해 준비된 초당 읽기 전용 트랜잭션 수입니다.The number of read-only transactions that were prepared for commit processing, per second.
Save point refreshes/secSave 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/secSave point rollbacks/sec 트랜잭션이 저장점으로 롤백된 초당 횟수입니다(평균).The number of times a transaction rolled back to a save point (on average), per second.
Save points created /secSave points created /sec 초당 생성된 저장점 수입니다(평균).The number of save points created (on average), per second.
Transaction validation failure/secTransaction validation failure/sec 유효성 검사 처리에 실패한 초당 트랜잭션 수입니다(평균).The number of transactions that failed validation processing (on average), per second.
Transactions aborted by user/secTransactions aborted by user/sec 사용자에 의해 중단된 초당 트랜잭션 수입니다(평균).The number of transactions that were aborted by the user (on average), per second.
Transactions aborted/secTransactions aborted/sec 사용자 및 시스템에 의해 중단된 초당 트랜잭션 수입니다(평균).The number of transactions that aborted (both by the user and the system, on average), per second.
Transactions created/secTransactions created/sec 시스템에서 생성된 초당 트랜잭션 수입니다(평균).The number of transactions created in the system (on average), per second.

XTP 트랜잭션은 디스크 기반 트랜잭션과 다르게 계산됩니다(Databases:Transactions/sec에 반영됨).XTP transactions are counted differently than disk-based transactions (as reflected in Databases:Transactions/sec). 예를 들어, created/sec 트랜잭션은 read/only 트랜잭션을 계산하지만 Databases:Transactions/sec는 그렇지 않습니다.For example, Transactions created/sec counts read/only transactions, while Databases:Transactions/sec does not.

참고 항목See Also

SQL Server XTP(메모리 내 OLTP) 성능 카운터SQL Server XTP (In-Memory OLTP) Performance Counters