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