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

Related content

• Monitor Resource Usage (Performance Monitor)