Overall Satisfaction with SQL Server Business Intelligence Manager
We're using SQL Server Business Intelligence Manager to monitor our SQL Server BI platforms (analysis services, reporting services, and integration services). It's great at collecting metrics and KPIs regarding query execution and performance for SSAS in both standard and cube models, and also provides great insights for packages executed by SSIS.
- Great monitoring capabilities for SSAS, SSRS, and SSIS.
- Tuning features for SSAS cubes.
- Configurable alerts.
- Some advanced features are hard to get without proper training.
- Usability has room for improvement.
- We've prevented several SSAS outages because of SQL Server Business Intelligence Manager's timely alerts.
- We've greatly reduced cubes calculation times with SQL Server Business Intelligence Manager's tuning features.
SQL Server Business Intelligence Manager does what SQL Server Management Studio should already do natively. So it actually fills up important gaps Microsoft left in its product.