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