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 PowerPivot 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 PowerPivot model, and present the source data as part of a report. Applies to tabular models deployed on an Analysis Services instance and PowerPivot 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 PowerPivot database. Applies to tabular models deployed on an Analysis Services instance and PowerPivot 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 PowerPivot database. Applies to tabular models deployed on an Analysis Services instance and PowerPivot 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 PowerPivot 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

Reference

Retrieving Metadata from an Analytical Data Source

Concepts

Developing with XMLA in Analysis Services

Use Dynamic Management Views (DMVs) to Monitor Analysis Services