The previous recipe explained what DMVs are and illustrated how they can be used to get various information about SSAS objects using the MDSCHEMA collection of DMVs.
In this recipe we're shifting the focus to another collection of DMVs, the DISCOVER collection which is the largest collection of DMVs. DMVs in that collection can be used to monitor the usage of the cube across all its aspects.
Start SQL Server Management Studio and connect to your SSAS 2008 R2 instance. Click on the New Query button and check that the target database is Adventure Works DW 2008R2.
As explained in the previous recipe, the MDX query environment supports SQL queries that use DMVs. We ...