---
title: "SQL Server, Cursor Manager Total object"
description: Learn about the SQLServer:Cursor Manager Total object, which provides counters to monitor cursors in SQL Server.
ms.custom: ""
ms.date: "07/12/2021"
ms.prod: sql
ms.prod_service: "database-engine"
ms.reviewer: ""
ms.technology: performance
ms.topic: conceptual
helpviewer_keywords: 
  - "SQLServer:Cursor Manager Total"
  - "Cursor Manager Total object"
author: WilliamDAssafMSFT
ms.author: wiassaf
---
# SQL Server, Cursor Manager Total object
 [!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]

  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](../system-dynamic-management-views/sys-dm-os-performance-counters-transact-sql.md) dynamic management view:

```sql
SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%Cursor Manager Total%';
```  
  
## See also  
 [Monitor Resource Usage (System Monitor)](../../relational-databases/performance-monitor/monitor-resource-usage-system-monitor.md)