Great monitoring and alerting for MS SSAS, SSRS and SSIS
April 05, 2019

Great monitoring and alerting for MS SSAS, SSRS and SSIS

Gedson Silva | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

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.
MS SQL Server provides nice monitoring tools for its core SQL engine, but that's not the case with the BI components (SSAS, SSRS and SSIS). SQL Server Business Intelligence Manager is great at filling this gap, providing valuable insights and alerts for these critical tools, and also great tuning capabilities for cubes.

SQL Server BI Manager Feature Ratings

Performance dashboard
9
Intelligent alerting
8
Top SQL
8
Historical trend data
7
Virtualization support
8