| title | SQL Server, Cursor Manager Total object | ||
|---|---|---|---|
| description | Learn about the SQLServer:Cursor Manager Total object, which provides counters to monitor cursors in SQL Server. | ||
| ms.custom | |||
| ms.date | 07/12/2021 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | performance | ||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
||
| author | WilliamDAssafMSFT | ||
| ms.author | wiassaf |
[!INCLUDE SQL Server]
The SQLServer:Cursor Manager Total object provides counters to monitor cursors.
This table describes the SQL Server Cursor Manager Total counters.
| Cursor Manager Total counters | Description |
|---|---|
| Async population count | Number of cursors being populated asynchronously. |
| Cursor conversion rate | Number of cursor conversions per second. |
| Cursor flushes | Total number of run-time statement recreations by cursors. |
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 '%Cursor Manager Total%';