Dynamic Management Views for SSAS
With SQL Server 2005 onwards we are provided with a set of DMVs. These DMVs allow us to monitor facts like which index is being used and which are not , where are IO bottlenecks , what is cache hit ratio and other stuff. But what about analysis service.
What if I want to know which of my hierarchies are being used , which are the aggregations that are not being used etc etc.
Well from SQL 2008 onwards you can have this capability.
Read more...Tags: dmv