Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS Rowset

SQL Server 2012

Provides information at the column and segment level about storage tables used by an Analysis Services database running in tabular or PowerPivot mode. This rowset is primarily used for troubleshooting and analysis.

Applies to: tabular models

The DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS rowset contains the following columns.

Column name

Type indicator

Restriction

Description

DATABASE_NAME

DBTYPE_WSTR

Yes

Specifies the tabular database.

The DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS rowset can be restricted by using this column. If omitted the current database is used.

CUBE_NAME

DBTYPE_WSTR

Yes

The name of the model.

The DISCOVER_STORAGE_TABLES rowset can be restricted by using this column.

MEASURE_GROUP_NAME

DBTYPE_WSTR

Yes

The name of the measure group.

PARTITION_NAME

DBTYPE_WSTR

Yes

The name of the partition.

DIMENSION_NAME

DBTYPE_WSTR

The name of the dimension.

TABLE_ID

DBTYPE_WSTR

The internal ID of the table segment.

COLUMN_ID

DBTYPE_WSTR

The internal ID of the column.

SEGMENT _NUMBER

DBTYPE_I8

The ordinal number of the table segment.

TABLE_PARTTION_NUMBER

DBTYPE_I8

The ordinal number of the partition.

RECORDS_COUNT

DBTYPE_I8

The number of records in the partition.

ALLOCATED_SIZE

DBTYPE_UI8

Size in bytes allocated to the column segment.

USED_SIZE

DBTYPE_UI8

Size in bytes used by the column segment.

COMPRESSION_TYPE

DBTYPE_WSTR

Type of compression applied to the column segment. This value is intended for internal use and customer support use only. Microsoft does not publish valid values or descriptions for this column.

BITS_COUNT

DBTYPE_I8

The count of bits.

BOOKMARK_BITS_COUNT

DBTYPE_I8

The count of bookmark bits.

VERTIPAQ_STATE

DBTYPE_WSTR

The state of the VertiPaq compression for this column segment. The value is one of the following:

  • SKIPPED – The VertiPaq compression was skipped.

  • COMPLETED – The VertiPaq compression completed successfully.

  • TIMEBOXED – The VertiPaq compression was timeboxed.

When using ADOMD.NET and the schema rowset to retrieve metadata, you can use either the GUID or string to reference a schema rowset object in the GetSchemaDataSet method. For more information, see Working with Schema Rowsets in ADOMD.NET.

The following table provides the GUID and string values that identify this rowset.

Argument

Value

GUID

a07ccd45-8148-11d0-87bb-00c04fc33942

ADOMDNAME

StorageSegments

The following query returns the storage table segments associated with the model attribute LastName, in the current database.

SELECT DISTINCT TABLE_ID, COLUMN_ID 
FROM $system.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS
WHERE COLUMN_ID = 'LastName'
ORDER BY TABLE_ID
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.