Report Portal

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


2007-2015 VidasSoft Systems Inc.