SQL Sentry BI Suite provides a complete performance monitoring and optimisation solution for the entire Microsoft BI platform by combining SQL Sentry Event Manager, Performance Advisor for SQL Server and Performance Advisor for Analysis Services.
It also covers Microsoft's entire BI stack including the relational data warehouse (SQL Server), SQL Server Integration Services (SSIS), Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).
SQL Sentry BI Suite is licensed per individual monitored instance. First year annual software maintenance is required and provides technical support via e-mail and phone, fixes and updates and free version upgrades.
SQL Sentry Event Manager
- Visual schedule management
- Alerting and response system
- SSIS, DTS and cross-platform support.
Performance Advisor for SQL Server
- Global server status view
- Improved performance reporting
- Automatic disk misalignment detection with comparison to disk latency
- Mount Points displayed alongside all other disks.
Performance Advisor for Analysis Services
- Performance Dashboard for SSAS with Microsoft Windows and SSAS performance metrics
- Performance profiling highlights bottlenecks in the formula engine, storage engine or elsewhere
- Captures and aggregates all high impact SSAS commands, pinpoints problem SSAS queries, generates alerts for SSAS commands and runtime deviations and provides a view of SSAS activity
- Monitoring and alerting for SSIS data warehousing and SSRS reports.