Friday, August 12, 2011

Microsoft SQL Server Community Samples: Analysis Services

Resmon exposes the Analysis Services 2008 DMVs as a cube, which could help expose performance problems and find resolution.

With Analysis Services 2008 and later, data from dynamic management views can be retrieved with SQL query syntax as described here. Therefore, it is possible to build an Analysis Services cube which uses Analysis Services DMV SQL queries as the data source.
The ResMon cube rolls up information about Analysis Services such as memory usage by object, perfmon counters, aggregation hits/misses, and current session stats.

Microsoft SQL Server Community Samples: Analysis Services

No comments: