Tuesday, July 14, 2009

SQL Sentry Announces Performance Optimization Software for SQL Server Analysis Services

the developer of award-winning software for Microsoft SQL Server, announced today the availability of monitoring and optimization software for Microsoft SQL Server Analysis Services. SQL Sentry Performance Advisor for Analysis Services 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.


"Building on the success of Performance Advisor for SQL Server, we are proud to bring exciting new capabilities to the market for managing Analysis Services," said Greg Gonzalez, President and CEO of SQL Sentry. "And when combined with SQL Sentry Performance Advisor for SQL Server and Event Manager, we are providing the only solution in the market covering Microsoft's entire BI platform, including the relational data warehouse (SQL Server), Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS)."


"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," said John Welch, SQL Server MVP, Chief Architect, Mariner.


Performance Advisor for Analysis Services is packed with many groundbreaking features, all designed to simplify the process of optimizing Analysis Services performance. Key Features include:


Powerful SSAS Performance Dashboard

Innovative Workload and Bottleneck Profiling

Capture of all High Impact MDX, XMLA and DMX Commands

Alerting and Response for SSAS Commands and Runtime Deviations

SSAS Cache and Storage System Monitoring

Calendar Views Combining SSAS, SQL Server, SSIS, and SSRS Events

Monitoring and Alerting for SSIS Data Warehousing Jobs and SSRS Reports Pricing and Availability