XML for Analysis Schema Rowsets

XML for Analysis Schema Rowsets

 

Applies To: SQL Server 2016 Preview

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.

Rowset1Description
DISCOVER_CALC_DEPENDENCY RowsetReturns 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 RowsetProvides resource usage and activity information about the currently opened connections on the server.
DISCOVER_COMMAND_OBJECTS RowsetProvides resource usage and activity information about the objects in use by the referenced command.
DISCOVER_COMMANDS RowsetProvides resource usage and activity information about the currently executing or last executed commands in the opened connections on the server
DISCOVER_CSDL_METADATA RowsetReturns 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 RowsetReturns a list of the XMLA Provider data sources that are available on the server or Web service.
DISCOVER_DB_CONNECTIONS RowsetProvides resource usage and activity information about the currently opened connections from the server to a database.
DISCOVER_DIMENSION_STAT RowsetReturns statistics on the specified dimension.
DISCOVER_ENUMERATORS RowsetReturns a list of names, data types, and enumeration values of enumerators supported by the XMLA Provider for a specific data source.
DISCOVER_JOBS RowsetProvides information about the active jobs executing on the server.
DISCOVER_KEYWORDS Rowset (XMLA)Returns information about keywords reserved by the XMLA provider.
DISCOVER_LITERALS RowsetReturns information about literals, including data types and values, supported by the XMLA provider.
DISCOVER_LOCATIONS RowsetReturns information about the contents of a backup file.
DISCOVER_LOCKS RowsetProvides information about the current standing locks on the server.
DISCOVER_MEMORYGRANT RowsetReturns a list of internal memory quota grants that are taken by jobs that are currently running on the server.
DISCOVER_MEMORYUSAGE RowsetReturns the memory usage statistics for various objects allocated by the server.
DISCOVER_OBJECT_ACTIVITY RowsetProvides resource usage per object since the start of the service.
DISCOVER_OBJECT_MEMORY_USAGE RowsetProvides information about memory resources used by objects.
DISCOVER_PARTITION_DIMENSION_STAT RowsetReturns statistics on the dimension that is associated with a partition.
DISCOVER_PARTITION_STAT RowsetReturns statistics on aggregations in a particular partition.
DISCOVER_PERFORMANCE_COUNTERS RowsetReturns the value of one or more specified performance counters.
DISCOVER_PROPERTIES RowsetReturns 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 RowsetReturns 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 RowsetProvides resource usage and activity information about the currently opened sessions on the server.
DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS RowsetProvides 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 RowsetAllows 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 RowsetReturns 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 RowsetDescribes the trace columns provided by the trace provider.
DISCOVER_TRACE_DEFINITION_PROVIDERINFO RowsetReturns basic information about the trace provider, such as its name and description.
DISCOVER_TRACE_EVENT_CATEGORIES RowsetDescribes the event categories provided by the trace provider.
DISCOVER_TRACES RowsetReturns information about traces running on a server.
DISCOVER_TRANSACTIONS RowsetReturns the current set of pending transactions on the system.
DISCOVER_XML_METADATA RowsetReturns 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.

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

Community Additions

ADD
Show:
© 2016 Microsoft