Note: SSAS DMVs are available in all versions after SQL Server 2005. You can write these SELECT statements in DMX window and not in SQL Query window as we run these queries on SSAS and not on relational databases.
We can query these views by simple T-SQL SELECT statement. But today I would like to focus specially on DMVs for monitoring SSAS ( SQL Server Analysis Services) and dig-down to find out how powerful it can be.ĭMVs for SSAS are known as “ Analysis Services Dynamic Management View“. As you must have heard or started using DMVs ( Dynamic Management View) available in SQL Server to get information about local server operations and server health.