sys.dm_column_store_object_pool (Transact-SQL)sys.dm_column_store_object_pool (Transact-SQL)

适用于: 是SQL Server是Azure SQL 数据库否Azure SQL 数据仓库否并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

返回的列存储索引对象的对象的内存池使用情况的不同类型的计数。Returns counts of different types of object memory pool usage for columnstore index objects.

列名Column name 数据类型Data type 描述Description
database_id int 数据库 ID。ID of the database. 这是在 SQL Server 数据库或 Azure SQL 数据库服务器的实例中是唯一的。This is unique within an instance of a SQL Server database or an Azure SQL database server.
object_id int 对象的 ID。ID of the object. 对象为 object_types 之一。The object is one of the object_types.
index_id int columnstore 索引的 ID。ID of the columnstore index.
partition_number bigint 索引或堆中从 1 开始的分区号。1-based partition number within the index or heap. 每个表或视图具有至少一个分区。Every table or view has at least one partition.
column_id int 列存储列的 ID。ID of the columnstore column. 这是对于 DELETE_BITMAP 值为 NULL。This is NULL for DELETE_BITMAP.
row_group_id int 行组的 ID。ID of the rowgroup.
object_type smallint 1 = COLUMN_SEGMENT1 = COLUMN_SEGMENT

2 = COLUMN_SEGMENT_PRIMARY_DICTIONARY2 = COLUMN_SEGMENT_PRIMARY_DICTIONARY

3 = COLUMN_SEGMENT_SECONDARY_DICTIONARY3 = COLUMN_SEGMENT_SECONDARY_DICTIONARY

4 = COLUMN_SEGMENT_BULKINSERT_DICTIONARY4 = COLUMN_SEGMENT_BULKINSERT_DICTIONARY

5 = COLUMN_SEGMENT_DELETE_BITMAP5 = COLUMN_SEGMENT_DELETE_BITMAP
object_type_desc nvarchar(60) COLUMN_SEGMENT-列段。COLUMN_SEGMENT - A column segment. object_id 是段 id。object_id is the segment ID. 一个段存储在一个行组中的一个列的所有值。A segment stores all the values for one column within one rowgroup. 例如,如果表有 10 个列,是每个行组的 10 个列段。For example, if a table has 10 columns, there are 10 column segments per rowgroup.

COLUMN_SEGMENT_PRIMARY_DICTIONARY-包含查找表中的列段的所有信息的全局字典。COLUMN_SEGMENT_PRIMARY_DICTIONARY - A global dictionary that contains lookup information for all of the column segments in the table.

COLUMN_SEGMENT_SECONDARY_DICTIONARY-本地字典具有一列相关联。COLUMN_SEGMENT_SECONDARY_DICTIONARY - A local dictionary associated with one column.

COLUMN_SEGMENT_BULKINSERT_DICTIONARY-全局字典中的另一种表示。COLUMN_SEGMENT_BULKINSERT_DICTIONARY - Another representation of the global dictionary. 这提供了对 dictionary_id 有价值的反向查找。This provides an inverse look up of value to dictionary_id. 用于创建元组发动机或大容量加载的一部分的压缩的段。Used for creating compressed segments as part of Tuple Mover or Bulk Load.

删除 COLUMN_SEGMENT_DELETE_BITMAP-跟踪段的位图。COLUMN_SEGMENT_DELETE_BITMAP - A bitmap that tracks segment deletes. 没有每个分区一个删除位图。There is one delete bitmap per partition.
access_count int 读取或写入此对象的访问的数。Number of read or write accesses to this object.
memory_used_in_bytes bigint 使用此对象中的对象池的内存。Memory used by this object in the object pool.
object_load_time datetime 当 object_id 已放入对象池的时钟时间。Clock-time for when object_id was brought into the object pool.

权限Permissions

SQL ServerSQL Server,需要VIEW SERVER STATE权限。On SQL ServerSQL Server, requires VIEW SERVER STATE permission.
SQL 数据库SQL Database高级层,需要VIEW DATABASE STATE数据库中的权限。On SQL 数据库SQL Database Premium Tiers, requires the VIEW DATABASE STATE permission in the database. SQL 数据库SQL Database标准版和基本层,需要服务器管理员Azure Active Directory 管理员帐户。On SQL 数据库SQL Database Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.

请参阅See Also

与索引相关的动态管理视图和函数 (Transact-SQL) Index Related Dynamic Management Views and Functions (Transact-SQL)
sys.dm_db_index_physical_stats (Transact-SQL) sys.dm_db_index_physical_stats (Transact-SQL)
sys.dm_db_index_operational_stats (Transact-SQL) sys.dm_db_index_operational_stats (Transact-SQL)
sys.indexes (Transact-SQL) sys.indexes (Transact-SQL)
sys.objects (Transact-SQL) sys.objects (Transact-SQL)
监视和优化性能Monitor and Tune for Performance