The new way to monitor BI - SQL Server Business Intelligence Manager
November 09, 2016

The new way to monitor BI - SQL Server Business Intelligence Manager

Samir Patel, PMP | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with SQL Server Business Intelligence Manager

We were using SQL Server BI Manager to monitor the health and availability of our entire SQL Server BI environment. This includes SSIS, SSRS and SSAS. The business problems that this addresses are all related to ensuring our customers get the best BI solutions available. Currently it is being used by our reporting department, but we assume it might spread shortly.
  • Shows an excellent dashboard
  • Allows easy monitoring of multiple instances
  • Created an environment that can be self healing
  • Drill down can kind of be cumbersome
  • Deep knowledge is needed to understand metrics
  • Some light training is needed to take advantage of all features
  • More efficiencies throughout the BI stack
  • Less employees needed for monitoring all the BI processing
  • Proactive error handling
We compared SQL Server Business Intelligence Manager to our current tool Solarwinds Database Performance Analyzer. Where Solarwinds was deficient, SQL BI manager filled the gap. At the end of the day they were both different tools with different purposes so we concluded it was best to have both for our organization.
SQL Server Business Intelligence Manager is well suited for organizations with large scale BI deployments. When tracking all of your SSIS, SSAS and SSRS processes that are spread out and disjointed, this tool will enable one user to get a holistic view of the whole environment. If you want to be proactive in handling performance issues before they happen, then this tool is good too.