Muokkaa

Jaa


SQL Server XTP IO Governor object

Applies to: SQL Server

The SQL Server XTP IO Governor performance object contains counters related to the In-Memory OLTP IO Rate Governor.

This table describes the SQL Server XTP IO Governor counters.

Counter Description
Insufficient Credits Waits/sec Number of waits due to insufficient credits in the rate objects (per second).
Io Issued/sec Number of Io issued per second by flush threads.
Log Blocks/sec Number of log blocks processed by controller per second.
Missed Credit Slots Number of credit slots missed because of wait for credits from rate object.
Stale Rate Object Waits/sec Number of waits due to stale rate objects (per second).
Total Rate Objects Published Total number of Rate objects published.

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 IO Governor%';