SQL Server XTP Databases object
Applies to: SQL Server
The SQL Server XTP Databases performance object provides In-Memory OLTP database-specific counters.
Note
The SQL Server XTP Databases counters are not currently visible from sys.dm_os_performance_counters
. On Windows, the counters can be viewed from System Monitor.
This table describes the SQL Server XTP Databases counters.
Counter | Description |
---|---|
Avg Transaction Segment Large Data Size | Average size of transaction segment large data payload. This is a very low-level counter, not intended for customer use. |
Avg Transaction Segment Size | Average size of transaction segment payload. If this value goes to zero, more pages are allocated from the backend allocator. This is a very low-level counter, not intended for customer use. |
Flush Thread 256K Queue Depth | Flush Thread queue depth for 256K IO requests. |
Flush Thread 4K Queue Depth | Flush Thread queue depth for 4K IO requests. |
Flush Thread 64K Queue Depth | Flush Thread queue depth for 64K IO requests. |
Flush Thread Frozen IOs/sec (256K) | The number of 256K IO requests encountered during flush page processing that are above the freeze threshold and thus cannot be issued. |
Flush Thread Frozen IOs/sec (4K) | The number of 4K IO requests encountered during flush page processing that are above the freeze threshold and thus cannot be issued. |
Flush Thread Frozen IOs/sec (64K) | The number of 64K IO requests encountered during flush page processing that are above the freeze threshold and thus cannot be issued. |
IoPagePool256K Free List Count | Number of pages in the 256K IO page pool free list. If this value goes to zero, more pages are allocated from the backend allocator. This is a very low-level counter, not intended for customer use. |
IoPagePool256K Total Allocated | Total number of pages allocated and held by the 256K IO page pool from the backend allocator. This is a very low-level counter, not intended for customer use. |
IoPagePool4K Free List Count | Number of pages in the 4K IO page pool free list. If this value goes to zero, more pages are allocated from the backend allocator. This is a very low-level counter, not intended for customer use. |
IoPagePool4K Total Allocated | Total number of pages allocated and held by the 4K IO page pool from the backend allocator. This is a very low-level counter, not intended for customer use. |
IoPagePool64K Free List Count | Number of pages in the 64K IO page pool free list. If this value goes to zero, more pages are allocated from the backend allocator. This is a very low-level counter, not intended for customer use. |
IoPagePool64K Total Allocated | Total number of pages allocated and held by the 64K IO page pool from the backend allocator. This is a very low-level counter, not intended for customer use. |
MtLog 256K Expand Count | Number of times a 256K MtLog was expanded. This is a very low-level counter, not intended for customer use. |
MtLog 256K IOs Outstanding | The number of outstanding 256K IO requests issued by MtLog. |
MtLog 256K Page Fill %/Page Flushed | Average fill percentage of each 256K MtLog page flushed. This is a very low-level counter, not intended for customer use. |
MtLog 256K Write Bytes/sec | Write bytes per second on 256K MtLog objects. This is a very low-level counter, not intended for customer use. |
MtLog 4K Expand Count | Number of times a 4K MtLog was expanded. This is a very low-level counter, not intended for customer use. |
MtLog 4K IOs Outstanding | The number of outstanding 4K IO requests issued by MtLog. |
MtLog 4K Page Fill %/Page Flushed | Average fill percentage of each 4K MtLog page flushed. This is a very low-level counter, not intended for customer use. |
MtLog 4K Write Bytes/sec | Write bytes per second on 4K MtLog objects. This is a very low-level counter, not intended for customer use. |
MtLog 64K Expand Count | Number of times a 64K MtLog was expanded. This is a very low-level counter, not intended for customer use. |
MtLog 64K IOs Outstanding | The number of outstanding 64K IO requests issued by MtLog. |
MtLog 64K Page Fill %/Page Flushed | Average fill percentage of each 64K MtLog page flushed. This is a very low-level counter, not intended for customer use. |
MtLog 64K Write Bytes/sec | Write bytes per second on 64K MtLog objects. This is a very low-level counter, not intended for customer use. |
Num Merges | The number of merges in flight. |
Num Merges/sec | The number of merges created per second (on average). |
Num Serializations | The number of serializations in flight. |
Num Serializations/sec | The number of serializations created per second (on average). |
Redo Active Worker | The number of active redo workers. |
Redo Log Processed Bytes/sec | Log bytes per second that Redo controller has processed. |
Redo Segment Definition/Sec | The number segments definitions seen per second. This is a very low-level counter, not intended for customer use. |
Tail Cache Page Count | Number of pages allocated in the Tail Cache. This is a very low-level counter, not intended for customer use. |
Tail Cache Page Count Peak | Highest number of pages allocated in the Tail Cache. This is a very low-level counter, not intended for customer use. |
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