| title | SQL Server XTP IO Governor object | |||
|---|---|---|---|---|
| description | Learn about the SQL Server XTP IO Governor performance object, which contains counters related to the In-Memory OLTP IO Rate Governor. | |||
| author | MikeRayMSFT | |||
| ms.author | mikeray | |||
| ms.date | 12/04/2023 | |||
| ms.service | sql | |||
| ms.subservice | performance | |||
| ms.topic | reference | |||
| helpviewer_keywords |
|
[!INCLUDE 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. |
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%';