Performance Advisor for Analysis Services (SSAS) is the first commercial software for monitoring and optimizing Microsoft SQL Server Analysis Services performance. Performance Advisor for SSAS provides unparalleled insight into Analysis Services performance issues, including bottlenecks related to memory and storage systems, aggregation usage, unoptimized queries, and query and processing tasks competing for the same resources.
The SQL Sentry BI Suite consists of Performance Advisor for SSAS, SQL Sentry Event Manager, and Performance Advisor for SQL Server, and is the only performance monitoring solution covering Microsoft's entire BI stack: the relational data warehouse (SQL Server), SQL Server Integration Services (SSIS), Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).
Performance Advisor for SSAS Features
Performance Dashboard for SSAS with both Windows and SSAS performance metrics side-by-side, providing a full picture of how SSAS is utilizing available network, CPU, memory and disk resources for any interval or over any date range.
Easily see how querying and processing tasks are utilizing and competing for the same resources, leading to reduced querying or processing performance.
Innovative performance profiling highlights bottlenecks in the formula engine, storage engine, or elsewhere over any date range.
Captures and aggregates all high impact SSAS commands (MDX, DMX and XMLA), showing top commands by CPU and I/O 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.
Generate alerts for SSAS commands and runtime deviations.
View SSAS internal cache activity, including hit ratios for all cache lookup types, as well as cache growth/shrinkage.
View SSAS-related disk activity and system file cache usage, including file cache hit ratios.
View SSAS commands on the Event Manager calendar, side-by-side with all other jobs and performance events on a server.
Create custom calendars combining all SSAS, SQL Server, SSIS, and SSRS events for a data warehouse.
Monitoring and alerting for SSIS data warehousing jobs.
The SQL Sentry BI Suite provides a performance monitoring solution for the entire Microsoft BI platform by combining SQL Sentry Event Manager, Performance Advisor for SQL Server and Performance Advisor for Analysis Services.
SQL Sentry Performance Advisor for Analysis Services is licensed per individual monitored Analysis Services instance. First year annual software maintenance
is required and provides technical support via e-mail and phone, fixes and updates and free version upgrades.