SQL Server, Cursor Manager by Type Object


Applies To: SQL Server 2016

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 countersDescription
Active cursorsNumber of active cursors.
Cache Hit RatioRatio between cache hits and lookups.
Cache Hit Ratio BaseFor internal use only.
Cached Cursor CountsNumber of cursors of a given type in the cache.
Cursor Cache Use Count/secTimes each type of cached cursor has been used.
Cursor memory usageAmount of memory consumed by cursors in kilobytes (KB).
Cursor Requests/secNumber of SQL cursor requests received by server.
Cursor worktable usageNumber of worktables used by cursors.
Number of active cursor plansNumber of cursor plans.

Each counter in the object contains the following instances:

Cursor Manager instanceDescription
_TotalInformation for all cursors.
API CursorOnly the API cursor information.
TSQL Global CursorOnly the Transact-SQL global cursor information.
TSQL Local CursorOnly the Transact-SQL local cursor information.

Monitor Resource Usage (System Monitor)

Community Additions