SSAS2008-Info.com

One of the cool new features coming in SQL Server 2008 Analysis Services are Dynamic Management Views (DMV).  Actually I never thought of them as DMVs coming from my background, but since everyone else calls them that, there's no reason we shouldn't either.

So what are they and how did they come about?

DMX users are most likely familiar with the syntax:

SELECT * FROM MyDataMiningModel.CONTENT

What you may not know is that this is really a DMX query against the MINING_CONTENT schema rowset - we simply exposed via the SQL-like syntax of DMX for convenience, placing a schema restriction on the model name.

Read more...