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)

Help and Information

Getting SQL Server 2005 Assistance