XML for Analysis Schema Rowsets

The Microsoft XML for Analysis (XMLA) provider includes schema rowsets that return metadata about server state, activity, and objects. Retrieving metadata is necessary if you are developing a client application that connects to an Analysis Services model whose structure and characteristics are variable.

Schema rowsets also provide insight into internal processes and operations that can help you monitor the server and troubleshoot problems. To better support ad hoc administrative tasks, you can run a Dynamic Management View (DMV) query against most schema rowsets. DMV queries return results in a readable, tabular format that you can view in Management Studio.

The following table lists and describes each XMLA schema rowset, and identifies whether it returns information specific to tabular data models.

In This Section

Rowset1 Description
DISCOVER_CALC_DEPENDENCY Rowset Returns information about dependencies among tables, columns, measures, and calculated column formulas.

Applies to tabular models deployed on an Analysis Services instance and Power Pivot models in Excel workbooks that run in a SharePoint environment.
DISCOVER_CONNECTIONS Rowset Provides resource usage and activity information about the currently opened connections on the server.
DISCOVER_COMMAND_OBJECTS Rowset Provides resource usage and activity information about the objects in use by the referenced command.
DISCOVER_COMMANDS Rowset Provides resource usage and activity information about the currently executing or last executed commands in the opened connections on the server
DISCOVER_CSDL_METADATA Rowset Returns an XML definition of a data source to a client that can consume a tabular or Power Pivot model, and present the source data as part of a report.

Applies to tabular models deployed on an Analysis Services instance and Power Pivot models in Excel workbooks that run in a SharePoint environment.
DISCOVER_DATASOURCES Rowset Returns a list of the XMLA Provider data sources that are available on the server or Web service.
DISCOVER_DB_CONNECTIONS Rowset Provides resource usage and activity information about the currently opened connections from the server to a database.
DISCOVER_DIMENSION_STAT Rowset Returns statistics on the specified dimension.
DISCOVER_ENUMERATORS Rowset Returns a list of names, data types, and enumeration values of enumerators supported by the XMLA Provider for a specific data source.
DISCOVER_JOBS Rowset Provides information about the active jobs executing on the server.
DISCOVER_KEYWORDS Rowset (XMLA) Returns information about keywords reserved by the XMLA provider.
DISCOVER_LITERALS Rowset Returns information about literals, including data types and values, supported by the XMLA provider.
DISCOVER_LOCATIONS Rowset Returns information about the contents of a backup file.
DISCOVER_LOCKS Rowset Provides information about the current standing locks on the server.
DISCOVER_MEMORYGRANT Rowset Returns a list of internal memory quota grants that are taken by jobs that are currently running on the server.
DISCOVER_MEMORYUSAGE Rowset Returns the memory usage statistics for various objects allocated by the server.
DISCOVER_OBJECT_ACTIVITY Rowset Provides resource usage per object since the start of the service.
DISCOVER_OBJECT_MEMORY_USAGE Rowset Provides information about memory resources used by objects.
DISCOVER_PARTITION_DIMENSION_STAT Rowset Returns statistics on the dimension that is associated with a partition.
DISCOVER_PARTITION_STAT Rowset Returns statistics on aggregations in a particular partition.
DISCOVER_PERFORMANCE_COUNTERS Rowset Returns the value of one or more specified performance counters.
DISCOVER_PROPERTIES Rowset Returns a list of information and values about the standard and provider-specific properties that are supported by the XMLA provider for the specified data source.
DISCOVER_SCHEMA_ROWSETS Rowset Returns the names, restrictions, description, and other information for all enumeration values and any additional provider-specific enumeration values supported by the XMLA provider.
DISCOVER_SESSIONS Rowset Provides resource usage and activity information about the currently opened sessions on the server.
DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS Rowset Provides information at the column and segment level about storage tables used by a tabular or Power Pivot database.

Applies to tabular models deployed on an Analysis Services instance and Power Pivot models in Excel workbooks that run in a SharePoint environment.
DISCOVER_STORAGE_TABLE_COLUMNS Rowset Allows the client to determine the assignment of columns to storage tables used by a tabular or Power Pivot database.

Applies to tabular models deployed on an Analysis Services instance and Power Pivot models in Excel workbooks that run in a SharePoint environment.
DISCOVER_STORAGE_TABLES Rowset Returns information about the tables used in a model.

Applies to tabular models deployed on an Analysis Services instance and Power Pivot models in Excel workbooks that run in a SharePoint environment.
DISCOVER_TRACE_COLUMNS Rowset Describes the trace columns provided by the trace provider.
DISCOVER_TRACE_DEFINITION_PROVIDERINFO Rowset Returns basic information about the trace provider, such as its name and description.
DISCOVER_TRACE_EVENT_CATEGORIES Rowset Describes the event categories provided by the trace provider.
DISCOVER_TRACES Rowset Returns information about traces running on a server.
DISCOVER_TRANSACTIONS Rowset Returns the current set of pending transactions on the system.
DISCOVER_XML_METADATA Rowset Returns an XML document describing a requested object.

1 All the schema rowsets listed here are supported by the MSOLAP data source provider for the Microsoft XMLA Provider.

See Also

Developing with XMLA in Analysis Services
Use Dynamic Management Views (DMVs) to Monitor Analysis Services
Retrieving Metadata from an Analytical Data Source