SQL Server, Cursor Manager by Type Object
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. |
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. |
See Also
Other Resources
Monitoring Resource Usage (System Monitor)