3. Performance Advisor for Analysis Services

SQL Sentry Performance Advisor for Analysis Services shows the most important Windows and Analysis Services performance metrics side-by-side in a single view, so you have the full picture at a glance. Easily see how querying and processing tasks are utilizing and competing for the same resources, leading to reduced querying or processing performance.

SSAS Bottleneck Analysis
Innovative performance profiling highlights bottlenecks in the formula engine, storage engine, or elsewhere over any date range. Instantly see where SSAS is spending most of its time handling requests.

Real Time	Historical

High Impact SSAS Command Analysis
Performance Advisor for Analysis Services captures and aggregates all high impact SSAS commands (MDX, DMX and XMLA), showing top commands by CPU and IO usage. Pinpoint problem SSAS queries, and see exactly how much formula and storage engine time each query is using, as well as the most heavily used partitions and aggregations.

The BI Suite Overview video shows how Performance Advisor for Analysis Services is integrated with Performance Advisor for SQL Server and Event Manager.

"Performance Advisor for Analysis Services is truly a game changer. This is the first software that brings all of the pertinent information together in a clear and concise fashion, providing a level of insight into Analysis Services performance that before now just hasn’t been possible."
-- John Welch, SQL Server MVP, Chief Architect, Mariner