Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
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.
This table describes the SQL Server XTP Cursors counters.
| Counter | Description |
|---|---|
| Cursor deletes/sec | The number of cursor deletes (on average), per second. |
| Cursor inserts/sec | The number of cursor inserts (on average), per second. |
| Cursor scans started /sec | The number of cursor scans started (on average), per second. |
| Cursor unique violations/sec | The number of unique-constraint violations (on average), per second. |
| Cursor updates/sec | The number of cursor updates (on average), per second. |
| Cursor write conflicts/sec | The number of write-write conflicts to the same row version (on average), per second. |
| Dusty corner scan retries/sec (user-issued) | The number of scan retries due to write conflicts during dusty corner sweeps issued by a user's full-table scan (on average), per second. This is a very low-level counter, not intended for customer use. |
| Expired rows removed/sec | The number of expired rows removed by cursors (on average), per second. |
| Expired rows touched/sec | The number of expired rows touched by cursors (on average), per second. |
| Rows returned/sec | The number of rows returned by cursors (on average), per second. |
| Rows touched/sec | The number of rows touched by cursors (on average), per second. |
| Tentatively-deleted rows touched/sec | The number of expiring rows touched by cursors (on average), per second. A row is expiring if the transaction that deleted it is still active (i.e. has not yet committed or aborted.) |
Example
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 Cursors%';