|
Performance Advisor for Analysis Services
Building on the success of Performance Advisor for SQL Server, SQL Sentry has developed 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, including bottlenecks related to memory and storage systems, aggregation usage, unoptimized queries, and query and processing tasks competing for the same resources.
Performance Advisor for Analysis Services is
combined with Event Manager and Performance Advisor for SQL Server to
provide the "SQL Sentry BI Suite". The suite provides the only
performance monitoring solution in the market covering Microsoft's entire BI stack, which
includes 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 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.
- 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.
- Monitoring and alerting for SSRS reports.
|
Pricing
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.
For a complete listing, view the product price list and online store.
| Performance Advisor for Analysis Services |
License $ |
Maintenance $ |
|
|
|
Performance Advisor for Analysis Services license:
|
$2,495 |
$499 |
|
|
| |
|
|
|
|
| SQL Sentry BI Suite |
License $ |
Maintenance $ |
Savings $ |
Discount % |
BI Suite includes:
- (1) Performance Advisor for Analysis Services license
- (1) Performance Advisor for SQL Server license
- (1) Event Manager EE for SQL Server license
|
$3,995 |
$799 |
($1,188) |
20% |
|
|
|
