What are SSAS DMVs?
SSAS Dynamic Management Views are Analysis Services schema rowsets exposed as tables that we can query using T-SQL SELECT statement. For example, to query discover_connections DMV, we can write:
select * from $system.discover_connections
DMV is more convenient to use than schema rowsets, because:
a) we use SELECT statement rather than XMLA
b) the output is a table rather than XML
Tags: dmv