SQL Server XTP (In-memory OLTP) Performance Counters
Applies to:
SQL Server
SQL Server provides objects and counters that can be used by Performance Monitor to monitor In-Memory OLTP activity. The objects and counters are shared across all instances of a given version of SQL Server on the machine, starting in SQL Server 2014 (12.x).
In the past the object and counter names began with XTP, as in XTP Cursors. Now starting with SQL Server 2016 (13.x), the names are like the following pattern:
- SQL Server <version> XTP Cursors
For <version> the value is the SQL Server XTP version year, for example, 2017.
SQL Server XTP Performance Objects
The following table describes SQL Server performance objects.
Performance object | Description |
---|---|
SQL Server XTP Cursors | The SQL Server XTP Cursors performance object contains counters related to internal In-Memory OLTP engine cursors. Cursors are the low-level building blocks the In-Memory OLTP engine uses to process Transact-SQL queries. As such, you do not typically have direct control over them. |
SQL Server XTP Databases | The SQL Server XTP Databases performance object provides In-Memory OLTP database-specific counters. |
SQL Server XTP Garbage Collection | The SQL Server XTP Garbage Collection performance object contains counters related to the In-Memory OLTP engine's garbage collector. |
SQL Server 2016 XTP IO Governor | The SQL Server XTP IO Governor performance object contains counters related to the In-Memory OLTP IO Rate Governor. |
SQL Server XTP Phantom Processor | The SQL Server XTP Phantom Processor performance object contains counters related to the In-Memory OLTP engine's phantom processing subsystem. This component is responsible for detecting phantom rows in transactions running at the SERIALIZABLE isolation level. |
SQL Server XTP Storage | The SQL Server XTP Storage performance object contains counters related to In-Memory OLTP storage in SQL Server. |
SQL Server XTP Transaction Log | The SQL Server XTP Transaction Log performance object contains counters related to In-Memory OLTP transaction logging in SQL Server. |
SQL Server XTP Transactions | The SQL Server XTP Transactions performance object contains counters related to In-Memory OLTP engine transactions in SQL Server. |
Related content
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho