Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
The SQLServer:Cursor Manager by Type object provides counters to monitor cursors, grouped by type.
This table describes the SQL Server Cursor Manager by Type counters.
| Cursor Manager by Type counters | Description |
|---|---|
| Active cursors | Number of active cursors. |
| Cache Hit Ratio | Ratio between cache hits and lookups. |
| Cache Hit Ratio Base | For internal use only. |
| Cached Cursor Counts | Number of cursors of a given type in the cache. |
| Cursor Cache Use Count/sec | Times each type of cached cursor has been used. |
| Cursor memory usage | Amount of memory consumed by cursors in kilobytes (KB). |
| Cursor Requests/sec | Number of SQL cursor requests received by server. |
| Cursor worktable usage | Number of worktables used by cursors. |
| Number of active cursor plans | Number of cursor plans. |
Each counter in the object contains the following instances:
| Cursor Manager instance | Description |
|---|---|
| _Total | Information for all cursors. |
| API Cursor | Only the API cursor information. |
| TSQL Global Cursor | Only the Transact-SQL global cursor information. |
| TSQL Local Cursor | Only the Transact-SQL local cursor information. |
Examples
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 by Type%';