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.
|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.|
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%';
Submit and view feedback for