| title | SQL Server, Columnstore Object | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 04/12/2016 | |
| ms.prod | sql | |
| ms.prod_service | database-engine | |
| ms.service | ||
| ms.component | performance-monitor | |
| ms.reviewer | ||
| ms.suite | sql | |
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| ms.assetid | ae663a49-012f-4ffe-a332-f03157843052 | |
| caps.latest.revision | 8 | |
| author | barbkess | |
| ms.author | barbkess | |
| manager | craigg | |
| ms.workload | Inactive |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
The SQLServer:Columnstore object provides counters to monitor columnstore index execution in [!INCLUDEmsCoName] [!INCLUDEssNoVersion].
The following table describes the [!INCLUDEssNoVersion] Columnstore counters.
| Columnstore counters | Description |
|---|---|
| Delta Rowgroups Closed | Number of delta rowgroups closed. |
| Delta Rowgroups Compressed | Number of delta rowgroups compressed. |
| Delta Rowgroups Created | Number of delta rowgroups created. |
| Segment Cache Hit Raio | Percentage of column segments that were found in the columnstore pool without having to incur a read from disk. |
| Segment Cache Hit Ratio Base | For internal use only. |
| Segment Reads/Sec | Number of physical segment reads issued. |
| Total Delete Buffers Migrated | Number of times tuple mover has cleaned up the delete buffer. |
| Total Merge Policy Evaluations | Number of times the merge policy for columnstore was evaluated. |
| Total Rowgroups Compressed | Total number of rowgroups compressed. |
| Total Rowgroups Fit For Merge | Number of source rowgroups fit for MERGE since the start of SQL Server. |
| Total Rowgroups Merge Compressed | Number of compressed target rowgroups created with MERGE since the start of SQL Server. |
| Total Source Rowgroups Merged | Number of source rowgroups merged since the start of SQL Server. |