SQL Server, Cursor Manager Total object

Applies to: SQL Server

The SQLServer:Cursor Manager Total object provides counters to monitor cursors.

This table describes the SQL Server Cursor Manager Total counters.

Cursor Manager Total counters Description
Async population count Number of cursors being populated asynchronously.
Cursor conversion rate Number of cursor conversions per second.
Cursor flushes Total number of run-time statement recreations by cursors.

Example

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 Total%';