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. |